<

SSMS failed to connect to SSIS

Published on
3,189 Points
189 Views
Last Modified:
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service does not exist as an installed service'”.

The Problem

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error Connecting to the Integration Services service on the computer failed with the following error: "The specified service does not exist as an installed service".



If you have more services installed as SQL Server engine, SSAS or SSRS and confirming that all of those services are up and running:


You will be able to see them in SSMS v17.x when browsing for services but realize that SSIS services it is not being listed:



The Solution

The solution is actually very simple but it is not so obvious. After many attempts to understand and solve this issue, a downgrade of the SSMS version eventually solved it. To connect to a SSIS 2016 instance you will need at least SSMS v16.5.3.

For some reason, SSMS v17.x (at the moment I am writing this article the last version is 17.2) has a limitation that does not let it be able to connect to any SSIS version prior to 2017. So if you need to use SSMS to work with SSIS the best you can do by now is to download and install SSMS v16.5.3.


Note: As stated above, this issue happens with SSMS v17.2 and previous minor releases of SSMS v17. It has been already reported to Microsoft so it is expected that in a future release this will be corrected. Meanwhile use an older version of SSMS when working with SSIS instances. You can track the SSMS releases bug fixes here to see when this specific bug will be fixed by Microsoft.

0
Comment
0 Comments

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Join & Write a Comment

Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month