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:
I get this 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.