Cannot connect to SQLServer Integration Services

Question

SQlServer version, 13.0.5893.48 and SSMS version 15.0.18424. Is the version difference causing this error message. Do I install 17.9.1?

Answer 1

Hi @Avyayah,

There is no need to connect to the Integration Services service. This feature is kept for backward compatibility with the obsolete SSIS 2005-2008.

For the reference:

This service is not required to create, save, and run Integration Services packages. SQL Server 2012 (11.x) supports the Integration Services service for backward compatibility with earlier releases of Integration Services.

https://learn.microsoft.com/en-us/sql/integration-services/service/integration-services-service-ssis-service?view=sql-server-ver16

You need to use SSIS Catalog and SSISDB instead. They are available starting from SSIS 2012 onwards. Please see below.

Answer 2

Hi @Avyayah,

Like Yitzhak Khabinsky said, there is no need to connect to the Integration Services service.

However, if you still want to connect to SQL Server Integration Services, please make sure that you have installed

Integration Services in SQL Server setup.

Install Integration Services (SSIS)

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 3

Hi @Avyayah,

While the error message is not very clear, we can guess that the problem is related to the difference between the SQL Server and SSMS versions.

In order to connect to the local Integration Services, the versions of the SSMS and SQL Server (on which SSIS is running) must be the same.

Follow this link to download the older version of SSMS.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 4

Why do you want to connect with SSMS to SSIS, there not really anything you could manage? In the past 15 years I did it once, only by curious and for testing.

Do I install 17.9.1?

At https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver16#1791