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

Question

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

sidney l 21

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

Here are some version details ...

Microsoft SQL Server 2012 (SP4-GDR) (KB4057116) - 11.0.7462.6 (X64)
SQL Server Configuration Manager -> Integration Services 11.0
Running "dtexec" on machine B says: Version 11.0.7462.6 for 64-bit
Machine B SSMS is - 11.0.7462.6
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!

2 answers

Your answer

Answer 1

Yitzhak Khabinsky 26,491

@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

sidney l 21 Reputation points

2021-02-28T18:38:52.813+00:00

Hi,

Thanks for responding.

I have read everything on the link you included. I'm aware of SSISDB and have used it as well. Since the issue in question is
an old version of SQL Server 2012, we don't intend to make any changes. We have many SSIS Packages running without the use of
SSISDB and they work fine. I'm just looking to resolve the connectivity to Integration Services running on Machine B using SSMS from Machine A.

Thank you.

Answer 2

Monalv-MSFT 5,926

Hi @sidney l ,

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

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.

sidney l 21 Reputation points

2021-03-01T13:17:11.86+00:00

Hi,

I don't have Integration Services installed on Machine A. I don't see it under Windows Services applet.
This is a desktop/client machine with only SSMS installed. It was installed via the SQL Server 2012 media several years ago.

One question I have is. I understand, for legacy Integration Services, the SSMS build number (version) needs to match the
SQL Server build number. Refer to my original post. Do ALL digits need to match?

Thanks
Monalv-MSFT 5,926 Reputation points

2021-03-04T09:59:50.723+00:00

Hi @sidney l ,

We should add features-Integration Service in SQL Server Installation Center.

Please refer to Add Features to an Instance of SQL Server (Setup) and SQL Server installation guide .

Best regards,
Mona
sidney l 21 Reputation points

2021-03-04T13:03:44.717+00:00

Can you explain why I need to install Integration Services on a SSMS client machine? This is user/developer machine.
As I understand, this is not a requirement.
Yitzhak Khabinsky 26,491 Reputation points

2021-03-04T18:19:02.41+00:00

@sidney l ,
You are right, it is not needed on a client machine.
Nobody installs SSIS, i.e. server side product, on a client machine.

Share via

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

2 answers

Your answer