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

Guía de herramientas básicas para estudiantes: 31 apps y webs imprescindibles para ayudarte con los estudios

Comando FOR para archivos BAT

How to Setup and Configure Your Own GitLab Server on Ubuntu 20.04