Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

How do I .... grant access permissions for SSIS to users?

SSIS access permissions are managed via Component Services. It is the DCOM object named MSDTSServer. Here are the steps to follow. 
  1. Component Services -> Computers -> My Computer -> DCOM Config -> MSDTSServer
  2. Right click on MSDTSServer
  3. Click properties
  4. Click on the Security tab
  5. Select Customize and add the users/groups to the Launch/Activation and Access tabs accordingly
  6. Add the user to the local Distributed COM Users group
  7. Restart the SSIS service

 

Comments

Posted by Joseph Fallon on 20 April 2011

Very helpful article

Sorry to be thick but how do you

"Add the user to the local Distributed COM Users group"

Posted by trunks17ph on 30 May 2011

@Joseph,

1. Right-click My Computer>Manage>Configuration>Local Users & Groups

2. Look for the Distributed COM Users group and add the account.

Posted by paisan49 on 14 July 2014

Could it be on other name for win 8, cuase I dont see MSDTSServer on my computer?

Posted by paisan49 on 14 July 2014

Could it be on other name for win 8, cuase I dont see MSDTSServer on my computer?

Leave a Comment

Please register or log in to leave a comment.