Monday, January 10, 2011

Access denied to remote DCOM on Win 2003

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.aspx
http://support.microsoft.com/?kbid=892500

No comments:

Post a Comment