Error with creating SQL Server maintenance plans
Thanks to: http://mssqllover.blogspot.com/
Step 2:
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
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
Publicar un comentario
Dime si la información de este blog te sirvio.