locked
SQL 2005 import export always fails with COM class error RRS feed

  • Question

  • Any import/export from SQL management studio is giving me this:

     

    Retrieving the COM class factory for component with CLSID {88D96A05-F192-11D4-A65F-0040963251E5} failed due to the following error: 8007045a.

     

    my instance is this version:

    Microsoft SQL Server 2005 - 9.00.3042.00 (X64)   Feb 10 2007 00:59:02   Copyright (c) 1988-2005 Microsoft Corporation  Developer Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)

     

    Any simple steps to solve this? Advice would be much appreciated

     

    Note: I also have Visual Studio 2008 SP1 installed, which I had read a while back might solve my previous difficulty with saving dtsx packages.......unfortunately seems not to be the case, just another bitty problem instead :/

    Tuesday, August 19, 2008 9:03 PM

Answers

  •  

    Downloaded and installed SQL Server 2008 - all is well with DTS and everything else I've tried so far.

    I think my SQL 2005 setup was just corrupt after all the add-ons/mucking around i had done.

     

    Thanks for your suggestions

    Monday, August 25, 2008 4:38 PM

All replies