SSIS Connection Problem, "The specified service does not exist as an installed service."

If you get the error "The specified service does not exist as an installed service.", please dont be panic!

This is a very common issue. Follow below steps to ride on it.

1. First, check the SSIS is installed in the server. for that go to services.msc and try to find the service "SQL Server Integration Services xx" [xx can be 12/13/14 ..]. If there is no service like this, means no SSIS has been installed in this server. OR if you find the service, please follow below steps.

2. This is must, use the same version of SSMS to access the SSIS. If you have the DB permission, then check the DB version. most luckily SSIS and DB version is same. To be sure the version number, I always pick the service number [for my case it was "SQL Server Integration Services 13"]. 13 means SQL Server 16!

3. Once you get the version number of SSIS/DB. Download the SSMS for the same version from here. after install, try to connect to SSIS, I hope you will win!


Also, you can download the Free Developer Edition of SQL Server (SSIS Included) from here .. https://www.microsoft.com/en-us/sql-server/sql-server-downloads