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.

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

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.

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

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.
    SQL Server Management Studio (SSMS) - Unable to Connect to SSIS - The Specified Service Does Not Exist as an Installed Service ssms17-ssis-03
  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

47 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.

    Reply
  • sorry the version that cannot connect is 13.0.16106.4

    Reply
    • In 2014, I believe that SSMS was still part of the installation, so you can use that to install the SSMS version you need.

      Reply
  • Hii for ssms 16.5.3 which sql server i can install to connect ssis?

    Reply
  • Thank you so much for this. It is almost impossible to find SSMS 2016 online now. This explanation and download link was much appreciated.

    Reply
  • Helpful…Thanks !!

    Reply
  • I downloaded the MSSM same matching version for SSIS and still didn’t work.

    Reply
  • Many thanks Pinal!

    Reply
  • 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.

    Reply
  • Dereje Shiferaw Kebede
    June 5, 2020 9:19 pm

    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

    Reply
  • Paul Godfrey
    July 1, 2020 8:40 pm

    Thank You ! Thank You :-) You have the answer.

    Reply
  • maddencircledme (@MaddenCircledMe)
    July 30, 2020 10:42 pm

    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?

    Reply
  • 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??

    Reply

Leave a Reply

Menu