Friday, February 10, 2012

Cannot Connect to a Remote SSIS Server

I originally posted this issue on the SSIS forum and it was suggested I cross post here. I'm trying to connect to the MSDB database on a remote SSIS server using the integration services connection listed in the drop down box on SQL Server 2005 Management Studio. Every connection attempt ends with an 'Access Is Denied' error message. I have full db_dtsadmin rights on the remote server. We followed the MSDN whitepaper on connecting to a remote SSIS server (the section on eliminating the Access Is Denied error - configuring rights for remote users). Nothing works, I always get the generic access denied error message. Are there other permissions that need to be assigned in conjunction with db_dtsadmin to get this to work? I wonder if there is something simple we're overlooking.

Thanks.

Can you include a link to your original post?

SQL Server does not respond to connection attempts with "Access Denied" messages, so you would need to do more investigation into who is returning that error message. To see if the connection request reaches the server, you can use Profiler. You could also look at the server error log (the ERRORLOG files) and search for connection errors - these would most likely appear as "Login failed for user ...". If the connection request does not reach the server, then the problem is elsewhere.

Thanks
Laurentiu

|||To connect to a remote SSIS server when you aren't in the Administrators group of the remote server you need to have Activation permissions (remote) for the MsDtsServer Comm Object (In the Component Services console) and also be a member of the Comm Plus Users local group (it's called something other than that, I can't remember the exact name).|||Also check this http://msdn2.microsoft.com/en-us/library/aa337083.aspx blog.

No comments:

Post a Comment