SSMS(SQL Server Management Studio) can not edit SQL Agent Job steps

Categories: Database; Tagged with: ; @ August 27th, 2012 21:39

After creating a new agent job in SSMS, I try to edit one of the steps, but got an error like this:

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)

This is a SQL2008R2 bug >link<

you can download and install the hotfix, from the bug page.

——————————————————————

or you can try this simple way, but it’s not stable for me:

Quit all SQL based applications (SSMS, BIDS etc), you dont have to stop sql service.

Go to Start -> All Programs -> Accessories and then right click on Command Prompt and choose run as administrator.

Now copy and past the following two lines in to the command window to register the DLL’s

This will register 64 bit DTS.dll
c:\windows\system32\regsvr32 "c:\Program Files\Microsoft SQL Server\100\DTS\Binn\dts.dll"

This will register 32 bit which is required as SSMS is a 32-bit application.
c:\windows\syswow64\regsvr32 "c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dts.dll"

Start SSMS and test that you can open and re-open jobs steps.

Job done!

from:

Cannot edit job steps in SQL Server 2008 R2 Management Studio on 64 bit windows.



// Proudly powered by Apache, PHP, MySQL, WordPress, Bootstrap, etc,.