none
SSIS connection error with - "The Specified service does not exist as an installed service". RRS feed

  • General discussion

  • Hi,

    https://social.msdn.microsoft.com/Forums/getfile/1502345 -- Image link for Connection Error

    I tried with all 16.x and 17.X versions of SSMS. But no luck. This issue is happening only for one user and he has all admin related permissions. 

    SQL Server is 2016 and SSMS also 16 version. Please help me in finding the fix or any workaround.

    Friday, November 8, 2019 8:11 PM

All replies

  • Have you tried SSMS 16.5.3? Also try running ssms as admin and then try to connect.


    Regards,
    Vaibhav

    Saturday, November 9, 2019 10:32 AM
  • Hi Vaibhav,

    Thank you for reply.

    Yes. I tested with both 16.5.3 & 16.4.1 versions and also launched ssms as admin. Still getting the same ERROR.

    And the strange part is .. the same user(X user)  can able to connect Integration services when he logs into other desktop( Y User's) where Integration services working fine for that desktop user (Y user).  But  'X' user can not able to connect from his Windows 10 machine.



    • Edited by shivak3 Monday, November 11, 2019 5:36 PM
    Monday, November 11, 2019 5:28 PM
  • Hi shivak3,

    It seems that the link you provided is broken.

    You can share screen shots here on the forum directly.

    Monday, November 11, 2019 5:53 PM
  • Account needs to be verified to post images and waiting for it.I am sorry. -Thank you..

    Below is text form that ERROR:

    TITLE: Connect to Server
    ------------------------------

    Cannot connect to dvp16d.

    ------------------------------
    ADDITIONAL INFORMATION:

    Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

    ------------------------------

    Connecting to the Integration Services service on the computer "SERVERNAME" 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.


    For help, click: http://go.microsoft.com/fwlink/?LinkId=506689

    ------------------------------

    Connecting to the Integration Services service on the computer "SERVERNAME" 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.


    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    Monday, November 11, 2019 8:13 PM
  • Hi Yitzhak Khabinsky,

    I also hope these details will also help to figure out the problem.

    I am using Using SQL Server 2016  on Server OS  Windows Server 2012 R2 .

    Desktop side using SSMS 16.4.1

    Windows 10 machine SSMS  client version details:

    Microsoft SQL Server Management Studio       : 13.0.15900.1
    Microsoft Analysis Services Client Tools           : 13.0.1700.281
    Microsoft Data Access Components (MDAC)     : 10.0.18362.1
    Microsoft MSXML                                              : 3.0 6.0
    Microsoft Internet Explorer                              : 9.11.18362.0
    Microsoft .NET Framework                               : 4.0.30319.42000
    Operating System                                           : 6.3.18362

    Monday, November 11, 2019 8:34 PM
  • Hi shivak3,

    It is clear to me what is going on even without a screen shot.

    Your SQL Server (and SSIS) version is 2016. You are trying to connect to Integration Services service in SSMS.

    • Starting from SSIS 2012 onwards SSIS became a server side software with SSISDB Catalog and SSISDB database.
    • There is no need to connect to Integration Services service in SSMS. It is a leftover functionality for backward compatibility with the obsolete versions of SSIS 2005 - 2008R2.

    To work with SSIS all you need to do is to connect to the relational DB Database Engine...

    Please see below.



    Monday, November 11, 2019 8:54 PM
  • Account needs to be verified to post images and waiting for it.I am sorry. 

    You can comment on below thread requesting to get your account verified. 

    BTW, are you sure that the other users are connecting to Integration Service in SSMS in their machines? Or is it Database engine that they are connecting to?


    Regards,
    Vaibhav

    Monday, November 11, 2019 9:29 PM
  • Hi Vaibhav,

    I am sure other users are connecting to Intergration Services only in SSMS. - Thank you.

    Monday, November 11, 2019 9:41 PM
  •  Hi Yitzhak,

    When I connect to Database Engine, I do not see any folders under Integration Services Catalogs like what you showed in the image.

    Monday, November 11, 2019 10:08 PM
  • Hi shivak3,

    First, you need to create SSISDB Catalog: Creating the SSIS Catalog

    After that it is all yours: SSISDB folders, projects, environments explanation


    Monday, November 11, 2019 11:41 PM
  • Hi Yitzhak,

    But I am wondering how other users in the group  can able to connect to Integration Services.

    Tuesday, November 12, 2019 2:50 PM
  • Hi shivak3,

    The same way. They need to connect to Database Engine in SSMS.

    After that Integration Services Catalogs in Object Explorer.

    Tuesday, November 12, 2019 3:15 PM
  • Hi Yitzhak,

    Sorry for asking the question wrongly.

    But I am wondering how other users in the group  can able to connect to Integration Services.  I did not create SSISDB catalog for those users.

    Only one user from the group can not able to connect and that user has all admin permissions to the server.

    I am trying to connect server remotely from Windows 10 machine. Am I missing any SSIS or SSMS supporting packages on windows 10 machine.

    -Thank you

    Tuesday, November 12, 2019 9:55 PM
  • Hi Yitzhak,

    Sorry for asking the question wrongly.

    But I am wondering how other users in the group  can able to connect to Integration Services.  I did not create SSISDB catalog for those users.

    Only one user from the group can not able to connect and that user has all admin permissions to the server.

    Hi shivak3,

    The Integration Service Catalog is one and only per SQL Server instance.

    You need to go to the SSISDB database and assign that use in question to the ssis_admin role.


    Tuesday, November 12, 2019 11:46 PM