0x8002801D Error Visual Studio 2008
When trying to create or save an SSIS package, I am getting the "Library Not Registered" error (0x8002801D). I have searched high and low and tried the fixes I've seen posted, but nothing has worked. I'm working in the following environment: HP laptop (4GB RAM, plenty of HDD space) Windows 7 Home Premium (64-bit) SQL Server 2008 R2 Developer Visual Studio 2008 Norton Security Suite Visual Studio Express 2010 (C#) Office 2010 Home and Business (in case it includes some kind of incompatible XML handler) I have tried the following (none of which have worked): Registered MSXML3, MSXML4, MSXML6 (system32 and sysWOW64) Registered DTS.dll, DTSComExprEval.dll, DTSConn.dll, DTSLog.dll, DTSPipeline.dll, DTSPipelinePerf.dll, and ExecPackageTask.dll other dlls in the DTS\BINN folder Initially I also had SQL 2005 Developer installed; I completely removed it and all its components I completely uninstalled and re-installed SQL 2008 R2 Modified Norton's firewall settings to give all of the listed SQL components "Allow" access Disabled Norton's firewall and modified the Windows firewall settings (since this didn't work re-enabled Norton's) While working on this I also experienced an 0x80070005 error which appears to be firewall-related. Thus far changing the firewall settings has had no impact on the problem. I am close to dropping a neutron bomb on my laptop - doing a system restore - but wanted to see if there were any other suggestions before I put myself through the hassle. Most of the solutions I'm seeing deal with SQL/VS 2005 and/or older versions of Windows. I was hoping someone could address this specific issue. Any suggestions would be greatly appreciated!Thanks! Tim
January 27th, 2011 8:14pm

Hi Tim. Have you installed the latest SQL Server SP? ALso, try regsvr : http://support.microsoft.com/kb/249873 Let us know if your problem is solved.http://thebipalace.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
January 27th, 2011 11:00pm

I applied the service pack for Visual Studio, but it did not help. I'm running SQL 2008 R2, so there is no SP for it. In an attempt to register the dlls, I ran the following commands from a batch file; I got the 0x80070005 error and an 0x802801c error, but nothing changed. c:\windows\syswow64\regsvr32 /u "C:\Program Files\Microsoft SQL Server\100\dts\binn\dts.dll" c:\windows\system32\regsvr32 /u "C:\Program Files (x86)\Microsoft SQL Server\100\dts\binn\dts.dll" c:\windows\syswow64\regsvr32 "C:\Program Files\Microsoft SQL Server\100\dts\binn\dts.dll" c:\windows\system32\regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\100\dts\binn\dts.dll" c:\windows\syswow64\regsvr32 /u "C:\Program Files\Microsoft SQL Server\100\dts\binn\DTSComExprEval.dll c:\windows\system32\regsvr32 /u "C:\Program Files (x86)\Microsoft SQL Server\100\dts\binn\DTSComExprEval.dll c:\windows\syswow64\regsvr32 "C:\Program Files\Microsoft SQL Server\100\dts\binn\DTSComExprEval.dll c:\windows\system32\regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\100\dts\binn\DTSComExprEval.dll c:\windows\syswow64\regsvr32 /u "C:\Program Files\Microsoft SQL Server\100\dts\binn\DtsConn.dll c:\windows\system32\regsvr32 /u "C:\Program Files (x86)\Microsoft SQL Server\100\dts\binn\DtsConn.dll c:\windows\syswow64\regsvr32 "C:\Program Files\Microsoft SQL Server\100\dts\binn\DtsConn.dll c:\windows\sysyem32\regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\100\dts\binn\DtsConn.dll c:\windows\syswow64\regsvr32 /u "C:\Program Files\Microsoft SQL Server\100\dts\binn\DTSLog.dll c:\windows\system32\regsvr32 /u "C:\Program Files (x86)\Microsoft SQL Server\100\dts\binn\DTSLog.dll c:\windows\syswow64\regsvr32 "C:\Program Files\Microsoft SQL Server\100\dts\binn\DTSLog.dll c:\windows\system32\regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\100\dts\binn\DTSLog.dll c:\windows\syswow64\regsvr32 /u "C:\Program Files\Microsoft SQL Server\100\dts\binn\DTSPipeline.dll c:\windows\system32\regsvr32 /u "C:\Program Files (x86)\Microsoft SQL Server\100\dts\binn\DTSPipeline.dll c:\windows\syswow64\regsvr32 "C:\Program Files\Microsoft SQL Server\100\dts\binn\DTSPipeline.dll c:\windows\system32\regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\100\dts\binn\DTSPipeline.dll c:\windows\syswow64\regsvr32 /u "C:\Program Files\Microsoft SQL Server\100\dts\binn\ExecPackageTask.dll c:\windows\system32\regsvr32 /u "C:\Program Files (x86)\Microsoft SQL Server\100\dts\binn\ExecPackageTask.dll c:\windows\syswow64\regsvr32 "C:\Program Files\Microsoft SQL Server\100\dts\binn\ExecPackageTask.dll c:\windows\system32\regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\100\dts\binn\ExecPackageTask.dll c:\windows\syswow64\regsvr32 /u "C:\Program Files\Microsoft SQL Server\100\dts\binn\MsDtsSrvrUtil.dll c:\windows\system32\regsvr32 /u "C:\Program Files (x86)\Microsoft SQL Server\100\dts\binn\MsDtsSrvrUtil.dll c:\windows\syswow64\regsvr32 "C:\Program Files\Microsoft SQL Server\100\dts\binn\MsDtsSrvrUtil.dll c:\windows\system32\regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\100\dts\binn\MsDtsSrvrUtil.dll c:\windows\syswow64\regsvr32 /u "C:\Program Files\Microsoft SQL Server\100\dts\binn\SQLTaskConnections.dll c:\windows\system32\regsvr32 /u "C:\Program Files (x86)\Microsoft SQL Server\100\dts\binn\SQLTaskConnections.dll c:\windows\syswow64\regsvr32 "C:\Program Files\Microsoft SQL Server\100\dts\binn\SQLTaskConnections.dll c:\windows\system32\regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\100\dts\binn\SQLTaskConnections.dll c:\windows\syswow64\regsvr32 /u c:\windows\syswow64\msxml3.dll c:\windows\syswow64\regsvr32 /u c:\windows\syswow64\msxml4.dll c:\windows\syswow64\regsvr32 /u c:\windows\syswow64\msxml6.dll c:\windows\syswow64\regsvr32 c:\windows\syswow64\msxml3.dll c:\windows\syswow64\regsvr32 c:\windows\syswow64\msxml4.dll c:\windows\syswow64\regsvr32 c:\windows\syswow64\msxml6.dll Thanks! Tim
January 28th, 2011 1:55am

Tim, 0x80070005 error is an authentication error. Check the permissions for the user creating and saving SSIS packages. Also, have look at this thread: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/89a1c5e2-e084-4527-b208-97a9dc751c94/ Np idea about the second error!http://thebipalace.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
January 30th, 2011 12:24am

Tim, 0x80070005 error is an authentication error. Check the permissions for the user creating and saving SSIS packages. Also, have look at this thread: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/89a1c5e2-e084-4527-b208-97a9dc751c94/ Np idea about the second error!http://thebipalace.wordpress.com/
January 30th, 2011 12:24am

I am the only user on this machine and have full administrator permissions. I have continued to look for a solution, but nothing I have tried has worked. Any additional thoughts would be greatly appreciated.Thanks! Tim
Free Windows Admin Tool Kit Click here and download it now
January 30th, 2011 5:40pm

I am the only user on this machine and have full administrator permissions. I have continued to look for a solution, but nothing I have tried has worked. Any additional thoughts would be greatly appreciated.Thanks! Tim
January 30th, 2011 5:40pm

I am the only user on this machine and have full administrator permissions. I have continued to look for a solution, but nothing I have tried has worked. Any additional thoughts would be greatly appreciated.Thanks! Tim
Free Windows Admin Tool Kit Click here and download it now
January 30th, 2011 5:40pm

If I were you, I would have uninstalled and re-install SQL Server and VS. This will update all the other component that SQL Server and VS depend on, like .NET framework.Please mark as answer if this helps. Thank you! http://thebipalace.wordpress.com
January 30th, 2011 8:24pm

Thanks for the suggestion, but I have already done so (more than once). I also edited the COM Security properties, as described in your previous post. I'm at a loss here and am close to wiping the entire system and starting over. While that would be a HUGE waste of time, it seems like a small investment compared to the hours I have already put in on this. Any other suggestions, short of a system restore, would be very much appreciated.Thanks! Tim
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2011 12:10am

I re-installed Windows 7 and SQL Server 2008R2 and fixed the issue. Too bad it had to come to that...Thanks! Tim
February 2nd, 2011 3:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics