Tuesday, July 22, 2014

SSIS Permissions - Access Denied

You would think these permissions would be handled within SQL Server or Management Studio, but that would be waaaay too easy.

To give someone access to SQL Server SSIS:

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 via services control panel


Taken from this article:
http://www.sqlservercentral.com/blogs/robert_davis/2008/08/13/How-do-I-grant-access-permissions-for-SSIS-to-users/

No comments:

Post a Comment