The specified service does not exist as an installed service - Trying to connect Integration Services

sidney l 1 Reputation point
2021-02-28T15:39:58.16+00:00

Hello,

I have two machines: machine A is the SSMS client while machine B is SQL Server 2012 where Integration Services
is running. When I tried to connect to SSIS from the SSMS client, I get this error

72724-ssis-error-1.jpg

Here are some version details ...

  1. Microsoft SQL Server 2012 (SP4-GDR) (KB4057116) - 11.0.7462.6 (X64)
  2. SQL Server Configuration Manager -> Integration Services 11.0
  3. Running "dtexec" on machine B says: Version 11.0.7462.6 for 64-bit
  4. Machine B SSMS is - 11.0.7462.6
  5. Machine A SSMS is - 11.0.7507.2

The only way I connect to Integration Services is to logon Machine B and use the SSMS on the machine.
Port 135 and "MsDtsSrvr.exe" are allowed. My client SSMS is 11.0 and so as my SQL Server 2012 and yet I can't
connect.

Can someone tell me what my problem is and explain how to fix this issue?

I really appreciate it!

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

2 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 25,566 Reputation points
    2021-02-28T17:54:15.85+00:00

    @sidney l ,

    I hope you are using SSIS SSISDB Catalog.
    Starting from the SSIS 2012 onwards there is no need in SSIS service.

    I recently answered a similar question.
    Please check my answer in the link below, and read the entire thread. There is valuable information in the comments. And pleased don't be lured into a wrong territory by the MS person "answer".
    ssis-service-cannot-launch-from-ssms


  2. Monalv-MSFT 5,896 Reputation points
    2021-03-01T02:15:47.3+00:00

    Hi @sidney l ,

    Please check if you install Integration Services in Machine A and Machine B.

    72668-installintegrationservice.png

    Best regards,
    Mona

    ----------

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

    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.