Error with creating SQL Server maintenance plans

Thanks to: http://mssqllover.blogspot.com/

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.

Comentarios

Entradas populares de este blog

Configuración de Hairpin NAT (VIP)

PNETLab installation / adding Huawei AR Router Image

Metadata Cleanup Using NTDSUTIL in Windows Server 2008 R2