FIX: SSMS : Can no longer create or edit job steps – Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed


Our customers reported issue while launching Job step dialog on SQL 2008 R2 ‘s Management Studio. Here is the related connection issue http://connect.microsoft.com/SQLServer/feedback/details/557402/ssms-can-no-longer-create-or-edit-job-steps

Issue: When attempting to add a step to a SQL Server Job,if you see this issue “Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)”,

Fixes:

SQL Server 2008 R2 SP1 – http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26727

SQL Server 2008 SP3 http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=27594

 

Comments (10)

  1. Bikrom Borthakur says:

    One of our instance runs SQL Ent 2008 SP3 and still have this error what else is there?

  2. sethus says:

    Can you check if your SSMS version is SQL Server 2008 SP3? Have you applied SQL 2008 SP3 on your machine running SSMS?

  3. Our instance running SQL Standard 2008 SP3 still have this error.

    Microsoft SQL Server Management Studio 10.0.5500.0

    Herramientas cliente de Microsoft Analysis Services 10.0.5500.0

    Microsoft Data Access Components (MDAC) 6.0.6002.18005

    Microsoft MSXML 3.0 5.0 6.0

    Microsoft Internet Explorer 9.0.8112.16421

    Microsoft .NET Framework 2.0.50727.4216

    Sistema operativo 6.0.6002

    Could you please help us?

  4. Donald lindo says:

    thank you I now have proof that the latest sp's should be installed

  5. Vikas singh says:

    Still same issue while editing,inserting job property.

    SQL Server 2008 SP3 http://www.microsoft.com/…/details.aspx is installed properly.

    Is there any alternate way to fix it.

  6. sethus says:

    Can you please check if you see this issue in SQL 2014. You can provision a SQL Server 2014 Virtual machine in Azure – azure.microsoft.com/…/virtual-machines-provision-sql-server

  7. Dejan says:

    I still have a problem with EDiting JOB steps and have

    SQL Server 2008 R2      10.50.6000.34 which means SP3 is installed.

    Is it that i need to upgrade SSMS

    THis is what i have:

    Microsoft SQL Server Management Studio                    10.50.1600.1

    Microsoft Analysis Services Client Tools                       10.50.1600.1

    Microsoft Data Access Components (MDAC)                3.85.1132

    Microsoft MSXML                                                                2.6 3.0 4.0 5.0 6.0

    Microsoft Internet Explorer                                               8.0.6001.18702

    Microsoft .NET Framework                                               2.0.50727.4455

    Operating System                                                                5.1.2600

    Is there any alternate way to fix this?

  8. Matt Jones MSFT says:

    Hello Dejan,

    Please update SQL Server Management Studio with the installers found on the SQL  Server 2008 R2 SP1 download page linked above: SQLManagementStudio_x64_ENU.exe or SQLManagementStudio_x86_ENU.exe (depending on your architecture).

    Thanks,

    Matt Jones

    SQL Server Tiger Team

  9. Dejan says:

    Thanks Matt.

    I ve found that implementing patch bellow also works.

    SQLServer2008R2-KB2261464-x86.exe

    Its installed on workstation which is using SSMS.