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
</body>
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