Unable to remote connect to SSIS

Question

I'm trying to connect to Integration Services hosted on a server from my client, but I can't!

The error message I'm getting is:

"Ett säkerhetspaketfel har uppstått." is swedish for: "A security package specific error occurred."

What is wrong? I can connect fine to the servers instance, and I can connect to SSIS locally from the server.

I can also connect to other SSIS on other servers just fine.. Maybe there is a tweak I must do?

Help please!

Answer 1

Thanks for your help. But as I said I can connect to it locally from the server. It is obviously running (I have checked - and tried restart..).

Answer 2

go to configuration manager on the remote computer

and

Check if the intergation services service is run using a local account

if so change it to network service and restart the service

Answer 3

It is running using a windows domain account. The same account as we use for other integration services and those works fine. But I don't know if anyone has done something other to them after the installation..? Is something else required?

Answer 4

When one connecting to SIS he/she needs to use just the host name, even though it is a named instance.

So when you are connecting to SSIS from SSMS make sure you specify it name as

SERVERInstanceABC and not SERVERInstanceABC\Name

---

Arthur My Blog

Answer 5

Hi Cloxy,

Besides Arthur's professional suggestion, please refer to the following link about how to connect to a Remote Integration Services Server:
http://msdn.microsoft.com/en-us/library/aa337083.aspx 

And here is a similar thread, please see: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/24eed7bd-b21a-4c64-9af2-8d0756ef727d/ 

Thanks,
Eileen

Answer 6

Thank you both for your suggestions.

I do connect to the servername, not with \instance. And it works on all my other SSIS on other servers.

I have read through both your links but they do not apply to my situation. I connect using a domain administrator account. And I can connect to the SSIS if I RDP to the server and start SSMS from there. No problem at all.

I have also tried reinstalling the SSIS service, but I keep getting the same mysterious error.

Answer 7

There could be some local or domain policy rules and/or Firewall settings preventing you from accessing this service remotely. Please investigate this route.

---

Arthur My Blog

Answer 8

Which Version of SSMS are using to connect??

what is the version of Integration services??

what is the OS version of the server ??

what is the OS version on which the client is installed??

This might be of help

http://www.ssistalk.com/2007/04/13/ssis-access-is-denied-when-connection-to-remote-ssis-service/

I have had similar issue in the past(i had done everything mentioned in the link but that didnt resolve the issue...wonder i was doiing something wrong..) 

Anyway was able to resolve it by changing the service to run under network service account rather than Windows domain account...

Note: My other services were running under windows domain account and i was able to connect to them but couldnt connect to integration services(remotely)