SQL Server Creating an instance of the COM

SQL Server : Creating an instance of the COM component with CLSID: Problem with creating maintenance plans

While working on a project to configure backup job , I had problem with creating maintenance plans in SQL 2008 R2, x64 as when tried to open maintenance plans got below mentioned error message . Second, it might happen that one can open the maintenance plans wizard, but at the time of submission, same error appears so same can be solved with below mentioned workaround.

Error Message:

========================================================================
Maintenance Plan Wizard Progress

- Creating maintenance plan "Daily backup (Error)
Messages
Create maintenance plan failed.
------------------------------
ADDITIONAL INFORMATION:

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)

------------------------------
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)

 ========================================================================
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Package..ctor()

OS: Windows 2008 R2 server SP2 (64bit)
SQL Server: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)

Workaround/ Fix :

1) Traverse to the C:\Program Files\Microsoft SQL Server\100\DTS\binn directory and run the following from the command:

REGSVR32.EXE dts.dll
2) You have to close the SSMS and re-open which will solve the problem.

Comments

Popular Posts

Install and configure rsyslog Centralized logging server in CentOS

How to fix postfix/smtp Network is unreachable error

Could not join realm: Necessary packages are not installed: sssd-tools sssd libnss-sss libpam-sss adcli