Category: SSIS

How to grant access on SSIS Server

SSIS access permissions are managed via Component Service under DCOM Config

1. Run  –> dcomcnfg.exe or Component Services -> Computers -> My Computer -> DCOM Config -> MSDTSServer

2.Right click on MSDTSServer or MSDTSServer100 ( based on SQL version )

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

How to add user in local Distributed COM Users group

  1. Right-click My Computer>Manage>Configuration>Local Users & Groups
  2. Look for the Distributed COM Users group and add the account.
Advertisements