Sunday, 29 March 2015

Error with creating maintenance plans

blogger tricks

Issue:

There are situations where a COM related error thrown while creating maintenance plan in SQL Server SSMS.


Error Message:
=======================================================================
==============================================================
Creating an instance of the COM component with CLSID {17BCA6E8-A95D-497E-B2F9-
AF6AA475916F} from the IClassFactory failed due to the following error: c001f011.
(Microsoft.SqlServer.ManagedDTS)




  

Step 1:

Traverse to the C:\Program Files\Microsoft SQL Server\100\DTS\binn directory and run the
Following from the command Prompt:
REGSVR32.EXE dts.dll




Step 2: 

Once done with registering the dts.dll you will get an successful information.




Step 3: You have to close the SSMS and which will solve the problem in creating the maintenance problem.



  

Maintenance plan will be created without any issues once the above troubleshooting is performed.

To study more about COM Class object and CLSID's Click Here


Appreciate your suggestions. Please comment your feedback and reach me out via email

Regards,
Ganapathi varma
Senior SQL Engineer, MCP





2 comments: