SQL Server Management Studio (SSMS) – Unable to Connect to SSIS – The Specified Service Does Not Exist as an Installed Service

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.

  1. Go to https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-ssms
  2. Search for “SSMS 16.5.3” and you should reach to the below image.
  3. 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)

, , , , ,
Previous Post
SCOM – Alert: SQL Server Cannot Authenticate Using Kerberos Because the Service Principal Name (SPN) is Missing, Misplaced, or Duplicated
Next Post
SQL SERVER – Error: 8509 – Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x8004d00e(XACT_E_NOTRANSACTION)

Related Posts

51 Comments. Leave new

Leave a Reply Cancel reply

Menu
Exit mobile version