After installing the latest version of SSMS (17.2), I was not able to connect to SQL Server Integration Services SSIS on my local machine.
Here is the text of the error message.
Connecting to the Integration Services service on the computer “LOCALHOST” failed with the following error: “The specified service does not exist as an installed service.”.
This error can occur when you try to connect to a SQL Server 2005 Integration Services service from the current version of the SQL Server tools. Instead, add folders to the service configuration file to let the local Integration Services service manage packages on the SQL Server 2005 instance.
This error can occur when you try to connect to a SQL Server 2005 Integration Services service from the current version of the SQL Server tools. Instead, add folders to the service configuration file to let the local Integration Services service manage packages on the SQL Server 2005 instance.
I checked services.msc to make sure it was running.
Above image confirmed that error message “The specified service does not exist as an installed service” is totally misleading.
WORKAROUND/SOLUTION
After trying various steps given on various sites, I was looking at the documentation and found https://docs.microsoft.com/en-us/sql/integration-services/service/integration-services-service-ssis-service#manage-the-service This says:
To connect directly to an instance of the legacy Integration Services, Service, you have to use the version of SQL Server Management Studio (SSMS) aligned with the version of SQL Server on which the Integration Services Service is running. For example, to connect to the legacy Integration Services, Service running on an instance of SQL Server 2016, you have to use the version of SSMS released for SQL Server 2016
Which means that, I need to download and install older version of SQL Server Management Studio. (16.5.3).
As of today, the download link is http://go.microsoft.com/fwlink/?LinkID=840946 which might change in the future so follow below steps.
- Go to https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-ssms
- Search for “SSMS 16.5.3” and you should reach to the below image.
- Click on the hyperlink to download
Hope this would help someone’s time as I wasted close to 30 min.
Reference: Pinal Dave (https://blog.sqlauthority.com)
53 Comments. Leave new
hi I am finding an issue with this: SSIS version 13.0.4001, people with SSMS version 13.0.1600.1 are able to connect to this version AS WELL AS upgraded versions of SSIS at 13.0.5233. BUT people with SSMS version 13.0.15106.4 (the current version of SSMS 2016 available) CANNOT connect to the SSIS on 13.0.4001. This is a large issue for us. Is it also a SSMS version issue? I cannot find the older version of SSMS to download and install on a test machine.
sorry the version that cannot connect is 13.0.16106.4
In 2014, I believe that SSMS was still part of the installation, so you can use that to install the SSMS version you need.
Hii for ssms 16.5.3 which sql server i can install to connect ssis?
Thank you so much for this. It is almost impossible to find SSMS 2016 online now. This explanation and download link was much appreciated.
Helpful…Thanks !!
I downloaded the MSSM same matching version for SSIS and still didn’t work.
Many thanks Pinal!
I am having the same problem for only one user and that user had all admin permissions to access the server. Still he is getting the same error even we installed lower versions of SSMS. The user is connecting SSIS using SSMS remotely from his workstation.
Others in the group can able to connect SSIS normally. I have been working on this issue for past two weeks. But no luck.
Really Appreciate your help.
Pinal you have no idea as to how much you have been helpful for my study and everyday work! I was having a problem of conecting SSIS with SQL server and the solution that you gave above has resolved it to me. Thanks
Thank You ! Thank You :-) You have the answer.
Dave, I’m experiencing this as well for SQL 2016 but I am using SSMS 16.5.3 and I can’t figure out what else could be causing this. Any ideas?
Hi
I am running Integration services 14.0
When trying to connect VIA SSMS 17.9.1 I get this error message too.
I tried also VIA SSMS 16.5.3 and also VIA newer versions like 18.X but in all of the versions I get the same annoying error message.
Suggestions anyone??
Hi Tzlil,
Did you ever find a solution?
Thanks,
Amy
NO…
I can connect to the integration services ONLY from SSMS on the SQL servers.
I cannot connect Via the clients.
Very very annoying and frustrating…
Thanks for this reminder post Pinal. This scenario always gets me because I deal with so infrequently.
Amazing…
I still did not find any solution to this problem.
I can connect to Integration Services ONLY from my SQL SERVERS machines.
I Can’t connect to it from any CLIENT with SSMS in any version.
Annoying and frustrating!!
Same for me
I am trying to connect SSIS 2012 with same version on SSMS still not able to connect and gives same error.