A fellow MVP, Jeff Johnson, has been having some issues (Access is Denied) with respect to connecting to a remote SSIS service. Books Online does not, apparently contain complete information. (Reference: http://msdn2.microsoft.com/en-us/library/aa337083.aspx)

Bottom line, a few steps should be added to that document to ensure your users can connect. (The root problem is the need to keep the user out of the server’s local administrator group.)

Instead of documenting them here, I’ll just point you to the thread that contains the complete picture. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=701950&SiteID=1

In summary:

  • Note: These steps are performed on the remote server that you cannot connect to
  • Edit Launch Permissions to include the Distributed COM (DCOM) user group
  • Be sure to customize “Access permissions” to include the Distributed COM (DCOM) user group
  • Make sure all remote access boxes are checed appropriately
  • Add the user account/group to the DCOM user group
  • You may need to restart the SSIS Service after making these changes — in fact, I recommend it.