2

On a server running Windows Server 2012 R2 Datacenter, I have installed MS SQL Server 2014, using a very typical installation. On a Windows 7 client, I have installed SQL Server Management Studio 2016. I am able to connect to my SQL Server (as a Database Engine) just fine using SSMS. However, when I try to use SSMS to connect to Integration Services on the exact same server host, like so:

Connect to Integration Services with SSMS

I get this error:

Class not registered Error

I do not believe I have SQL Server 2005 Integration Services installed since I did an out-of-the-box SQL Server 2014 installation, and I would expect (hope, at least) that the Integration Services matched.

However, I am able to deploy SSIS packages just fine and run them using SSMS from the Integration Services Catalog. I only run into issues when trying to log in directly to Integration Services or access the SSIS Package Store.

The version of SQL Server is 12.0.4459.0 (this is also the version of my Integration Services service, MsDtsSrvr.exe).

How do I resolve this?

  • Did you try downloading and using SSMS 2014 to see if you can connect? This problem used to come up when using different versions of SSIS and SSMS. – Mer Aug 29 '16 at 19:50
  • I actually hadn't considered that as a problem! I just installed SSMS 2014 instead of SSMS 2016, and ... now I get a different error (RPC Server is not available), but that gives me a new lead to follow! If I can get that figured out, then your suggestion will be the correct answer. – Michael Plautz Aug 30 '16 at 14:06
  • Are you able to connect if you turn the firewall off on SQL Server? – Mer Aug 30 '16 at 14:14
  • Yes I am. Brilliant! You can post this as an answer if you'd like and I'll accept it, otherwise I'll post the answer. – Michael Plautz Aug 30 '16 at 14:49
8

Did you try downloading and using SSMS 2014 to see if you can connect? This problem used to come up when using different versions of SSIS and SSMS.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.