Tuesday, July 20, 2010

Access Denied to SSIS remotely

Note: These steps are performed on the remote server that you cannot connect to:
  • If the user is not a member of the local Administrators group, add the user to the Distributed COM Users group. You can do this in the Computer Management MMC snap-in accessed from the Administrative Tools menu.
  • Open Control Panel, double-click Administrative Tools, and then double-click Component Services to start the Component Services MMC snap-in.
  • Expand the Component Services node in the left pane of the console. Expand the Computers node, expand My Computer, and then click the DCOM Config node.
  • Select the DCOM Config node, and then select MsDtsServer in the list of applications that can be configured.
  • Right-click on MsDtsServerXXX and select Properties.
  • In the MsDtsServer Properties dialog box, select the Security tab.
  • Edit "Launch Permissions" to include the Distributed COM (DCOM) user group with
    • Remote Launch
    • Remote Activation
  • Be sure to customize “Access permissions” to include the Distributed COM (DCOM) user group with "Remote Access"
  • Make sure all remote access boxes are checked appropriately
  • Restart the SSIS Service after making these changes.
Update 1/12/2011: When deploying remotely, make sure you specify "sqlserver\instance"
Reference: http://msdn.microsoft.com/en-us/library/aa337083.aspx

No comments:

Post a Comment