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

Post a Comment

Popular Posts

Install and configure rsyslog Centralized logging server in CentOS

-
 Install and configure rsyslog Centralized logging server in CentOS 6.5 In this tutorial we will learn, how to install and configure rsyslog 7.6 version on RHEL 6.5/CentOS 6.5 .The scenario is, install and setup rsyslog Centralized Logging Server in RHEL/CentOS 6.5. All the logs from client servers will be sent to Centralized logging server i.e rsyslog server. Check Pre-installed rsyslog package Step 1: First of all check the rsyslog package is installed in your system.Generally by-default we get rsyslog version 5.x , after minimal installation of CentOS 6.x / RHEL 6.x We will install the latest rsyslog package. At the time of writing this post, rsyslog stable version 7.6 was available. You can find the latest package information from rsyslog official website Note: By default, RHEL 6.x and CentOS 6.x has rsyslog version 5.x. So here we will update the rsyslog with new version. You can get the rsyslog version information, by using below given two commands rpm -qa|grep rsy...
Read more

Connecting to Your Linux Instance from Windows Using PuTTY

-
Image
1.     To generate an RSA key pair to work with version 2 of the protocol, type the following command at a shell prompt: 2.   ssh-keygen -t rsa [pravesh@localhost ~]$ ssh-keygen -t rsa Generating public/private rsa key pair. Enter file in which to save the key (/home/pravesh/.ssh/id_rsa): pravesh Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in pravesh. Your public key has been saved in pravesh.pub. The key fingerprint is: ed:5e:fb:5d:87:a2:12:ac:5d:98:1c:59:df:e3:81:1a pravesh@localhost.localdomain The key's randomart image is: +--[ RSA 2048]----+ |                 | |          .      | |         o . o   | |        o.E o +  | | ...
Read more

How to fix postfix/smtp Network is unreachable error

-
While configuration postfix authentication getting the error status=deferred (delivery temporarily suspended: connect to smtp.office365.com[2603:1026:3:ca::2]:587: Network is unreachable) its because of you were not using IPv6/ wrong settings for ipv6. You can either use IPv4, or correct your IPv6 settings. [root@mailserver postfix]# netstat -nutlap | grep 25 tcp        0      0 0.0.0.0:25              0.0.0.0:*               LISTEN      3956/master tcp        0      0 127.0.0.1:38442         127.0.0.1:3306          ESTABLISHED 2596/httpd [root@mailserver postfix]# vi /etc/postfix/main.cf [root@mailserver...
Read more