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?
2012年3月16日 16:49Thanks 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..).
go to configuration manager on the remote computer
Check if the intergation services service is run using a local account
if so change it to network service and restart the service
2012年3月16日 16:56It 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?
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
- 已建议为答案 Zaim Raza 2012年3月19日 12:22
2012年3月19日 2:50版主Hi Cloxy,
Besides Arthur's professional suggestion, please refer to the following link about how to connect to a Remote Integration Services Server:
And here is a similar thread, please see: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/24eed7bd-b21a-4c64-9af2-8d0756ef727d/
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.
2012年3月19日 15:17版主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
- 已建议为答案 Eileen ZhaoMicrosoft Contingent Staff, Moderator 2012年3月29日 8:31
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
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)