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

ora 21 Reputation points

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


SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,464 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Nitish Sharma 341 Reputation points

    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 No comments

  2. Yitzhak Khabinsky 25,201 Reputation points

    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 No comments

  3. ZoeHui-MSFT 33,386 Reputation points

    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.




    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.



    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.