How to grant access permission for SSIS

On a basic level, the quickest way to grant permissions to remotely access SSIS to a user that is not an admin of the server is:

  • Open Control Panel – Administrative Tools – Component Services
  • Expand the Component Services node and then Computers – My Computer – DCOM Config
  • Right click on MSDTSServer and select Properties
  • Select the Security tab
  • Select Customize and then add the required user/group to the Launch and Activate Permissions and Access Permissions giving them the required rights
  • Also add the user to the Distibuted COM Users local group through Computer Management – Local Users and Groups
  • Restart the SQL Server Integration Services service

Job done!

Advertisements

Tags: ,

Trackbacks / Pingbacks

  1. Access to granting users to access SSIS | Sql010 - November 24, 2015

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: