- 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.
Reference: http://msdn.microsoft.com/en-us/library/aa337083.aspx
No comments:
Post a Comment