Share via

Not able to connect to SSIS 2016 using SSMS 2016 from desktop

ora 21 Reputation points
2022-03-08T17:19:41.92+00:00

From my local machine/desktop with SSMS 2016 i am not able to connect to sql server integration services 2016 and getting error the specified service doesn't exist as an installed service.

SSIS is running on the server and my desktop doesn't have the integration services. I just have SSMS 2016.

What else could be the issue here? Any ideas? Thanks in advance

![181083-image.png]1

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nitish Sharma 341 Reputation points
    2022-03-08T18:02:24.493+00:00

    Hi @ora

    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

    Please can you share the version details of all the components for better understanding.

    0 comments
  2. Yitzhak Khabinsky 25,731 Reputation points
    2022-03-08T19:22:42.127+00:00

    Hi @ora ,

    There is absolutely no need in SQL Server Integration Services (SSIS) service.
    It is kept just for backward compatibility with the obsolete SSIS 2005-2008.

    Please see my full answer here: ssis-service-cannot-launch-from-ssms

    0 comments
  3. ZoeHui-MSFT 35,556 Reputation points
    2022-03-09T02:04:09.683+00:00

    Hi @ora ,

    If you want to connect to integration service via SSMS as shown below, you may need to install Integration Services in SQL Server Installation Center.

    install-integration-services

    181234-image.png

    181167-image.png

    However, as YitzhakKhabinsky-0887 said that, there is no need to add the feature, you may use Integration Services Catalog.

    To create the SSISDB catalog in SSMS, you may refer to ssis-catalog.

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.