question

sidneyl-9298 avatar image
0 Votes"
sidneyl-9298 asked Monalv-msft edited

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

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
ssis-error-1.jpg (34.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered sidneyl-9298 commented

@sidneyl-9298,

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·
Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @sidneyl-9298 ,

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.




· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

Hi @sidneyl-9298 ,

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


0 Votes 0 ·

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.

0 Votes 0 ·
Show more comments