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



    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