Cannot connect to SQLServer Integration Services

Avyayah 1,271 Reputation points
2023-04-26T19:17:45.24+00:00

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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,082 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,488 questions
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 25,386 Reputation points
    2023-04-26T19:33:12.1333333+00:00

    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.

    ssis-database-and-catalog


  2. ZoeHui-MSFT 34,581 Reputation points
    2023-04-27T01:50:07.37+00:00

    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.

    0 comments No comments

  3. ZoeHui-MSFT 34,581 Reputation points
    2023-04-28T02:41:21.87+00:00

    Hi @Avyayah,

    User's image

    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.

    0 comments No comments

  4. Olaf Helper 42,486 Reputation points
    2023-04-28T06:21:47.7533333+00:00

    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

    0 comments No comments