Archive

Archive for the ‘SQL Agent’ Category

error while Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2}

July 12, 2013 1 comment

Hi There ,

got below error while trying to EDIT a job which .. i have created and edited few times earlier..

EDIT_JOB_Failure
COMPLETE Error –> TITLE: Microsoft SQL Server Management Studio
——————————

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)

——————————
ADDITIONAL INFORMATION:

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)

——————————
BUTTONS:

OK
——————————

it turns out that few people already faced this issue and reported on below connect linK

http://connect.microsoft.com/SQLServer/feedback/details/557402/ssms-can-no-longer-create-or-edit-job-steps

My SSMS and Shared features as below ::

Microsoft SQL Server Management Studio 10.50.1617.0
Microsoft Analysis Services Client Tools 10.50.1617.0
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.3634
Operating System 5.1.2600

Solution : Try any one of the below workaround as your environment permits (as no single one has worked for all)

(Restarting the SSMS is what works as the first solution … but as we may have few scripts already typed in SSMS .. we would prefer a longer fix)

1> Run your SSMS as administrator

2> disable UAC

3> if on SQL2008 .. then install SP3

4> if using SQL 2008 R2 .. then install SP1

refer post :: http://blogs.msdn.com/b/sqlagent/archive/2012/01/20/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.aspx

related post :: http://support.microsoft.com/kb/2315727/en-us

hope this is helpful to you 🙂

Advertisements