If you're trying to remotely connect to SSIS on SQL server 2005/2008 and get "access is denied", check the Event Viewer (should be in the System log) on the server, and you should see DCOM errors showing the user trying to do "Remote Activation" and an ANONYMOUS LOGON trying to do a "Remote Access".
- If you do, you'll need to go into Component Services and edit properties on the computer node.
- On the COM Security tab,
- Click the Edit Limits buttons to make the updates.
Reference:
http://msdn.microsoft.com/en-us/library/aa337083.aspxhttp://support.microsoft.com/?kbid=892500
No comments:
Post a Comment