Tag: Permissions

SQL Server Integration Services Access

microsoft-sql-server

Pre-SQL 2012 versions, by default when SQL Server Integration Services was installed, all the users in the Users group has access to the Integration Services service. The service is secure by default. Post-Installation you need to grant admin access to the relevant DBAs and users.

To grant access to the IS Service:

  1. Run Dcomcnfg.exe from the server;
  2. Expand Component Services -> Computers -> My Computer -> DCOM Config;
  3. Find Microsoft SQL Server Integration Services ## object, right click and select properties.
    ## indicates the SQL Server version. Eg. SQL Server 2012 is 11.0, SQL Server 2014 is 12.0 etc.

sqlintegrationservices1

  1. Click on the Security tab, and click Edit under the Launch and Activation Permissions section.

sqlintegrationservices2

  1. Add the SQL Server Administrators group and any additional users, and click all Allow options.

sqlintegrationservices3

  1. Repeat Steps 4 & 5 for Access Permissions section.
  2. Restart SQL Server Integration Services and SQL Server to reflect the new changes.