Microsoft SQL Server on Windows Azure Virtual Machines

The writers of this blog are a part of the Microsoft SQL Server team. We will be blogging about our tools, scripts, webcasts, and miscellaneous tips that will help you get the most out of SQL Server components on Windows Azure Virtual machines

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

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

  • Comments 6

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

 

Leave a Comment
  • Please add 6 and 4 and type the answer here:
  • Post
  • One of our instance runs SQL Ent 2008 SP3 and still have this error what else is there?

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

  • 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?

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

  • Still same issue while editing,inserting job property.

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

    Is there any alternate way to fix it.

  • 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

Page 1 of 1 (6 items)