Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

Error: Creating an instance of the COM component with CLSID from the IClassFactory failed

Discussion in 'General' started by Peter Schmitz, Oct 1, 2012.

  1. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    While attempting to edit a job in SQL Server Management Studio (SSMS) on a SQL Server 2008 R2 installation (Version 10.50.1600 - Gold release, without any service packs), I started seeing the following error:

    The only workaround was closing down SSMS altogether, restarting it and then editing the job. Quite annoying, really. Luckily, this can be solved easily. Unlike Microsoft states on the first result in Google when searching for this error (their solution is updating to Cumulative Update 6 for SQL Server 2008 R2), the solution is ensuring that the dts.dll file is registered properly.

    To achieve this, you must first find the location where SSMS is installed For most newer (64 bit) installation, this could be either in the Program Files or the Program Files (x86) folder. You can figure out which location applies to you by right-clicking the SSMS link in your Start menu and selecting "Properties":

    dts ll error 1.png

    In the "Target" text box, the installation path will be shown:

    dts ll error 2.png

    In my case, this is at:

    "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

    Hence, I need to check the C:\Program Files (x86)\ folder. The full path to where the file resides on my system is:

    "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn".

    Verify that in the folder on your system, there is a file called dts.dll. Once you have all this information, click Start -> All Programs -> Accessories. There, locate the shortcut called "Command Prompt". Right-click it and then select "Run as Administrator":

    dts ll error 3.png
    You might be prompted to verify that you do want to allow the action. Then, navigate to the proper folder. In my case, this was achieved by running the following command:

    Code (text):

    cd C:"\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn"
     
    Then the command to properly register the dts.dll file is:

    Code (text):
    regsvr32 dts.dll
    You will receive a confirmation when the action was successful:

    dts ll error 4.png
  2. vongsi

    vongsi New Member

    Thanks for sharing such good tips. Not sure if someone have used this and if it really helped?

Share This Page