Connecting to SQL server integration service through SSMS failed with error- Class Not Registered

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses.

Scenario:-

Have you ever tried connecting SQL server integration service through management studio and failed to connect and receive error like Class not registered?

I recently working on importing SSIS package for my client and tried to connect integration service through SSMS and got this error.

Initially you wont see the server name while browsing for the server and if you try to put the server name manually and think to connect it, you will receive this error (Class Not Registered) on local machine.

 

 

Solution:

  • This happens due to change in the version of SQL server and SSMS-management studio.
  • Verify their respective version and install SSMS with the same version as SQL server.
  • Once done, open the SQL server management studio with Administrator and now connect the integration service.

Error is gone! Happy learning!

 

A man is born alone and dies alone; and he experiences the good and bad consequences of his karma alone; and he goes alone to hell or the Supreme abode.

Chanakya

 

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s