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

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

SQL Server Soldier :: News from the frontlines of the database wars

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

Posted on 13 August 2008
Comments
Briefcase
Print

SSIS access permissions are managed via Component Services. It is the DCOM object named MSDTSServer. Here are the steps to follow.

Component Services -> Computers -> My Computer -> DCOM Config -> MSDTSServer
Right click on MSDTSServer
Click properties
Click on the Security tab
Select Customize and add the users/groups to the Launch/Activation and Access tabs accordingly
Add the user to the local Distributed COM Users group
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.

Leave a Comment

Please register or log in to leave a comment.