Thursday, February 19, 2015

Granting a access to SSIS server



To grant access to the Integration Services service

  1. Run Dcomcnfg.exe. Dcomcnfg.exe provides a user interface for modifying certain settings in the registry.
  2. In the Component Services dialog, expand the Component Services > Computers > My Computer > DCOM Config node.
  3. Right-click Microsoft SQL Server Integration Services 11.0, and then click Properties.
  4. On the Security tab, click Edit in the Launch and Activation Permissions area.
  5. Add users and assign appropriate permissions, and then click Ok.
  6. Repeat steps 4 - 5 for Access Permissions.
  7. Restart SQL Server Management Studio.
  8. Restart the Integration Services Service.
            a) On the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager.

           b) In the SQL Server Configuration Manager snap-in, locate SQL Server Integration Services in the list of services, right-click SQL Server Integration Services, and then click Restart
  9. Account might require sysdba role, if the following error shows up.
    "The Execute permission was denied on the object 'sp_ssis_listfolders'.

1 comment:

  1. You probably dont know this. But there is more than 1 version of SQL server and this approach cant be used on for example SQL server 2008 which means people waste more of their time before they can see you guide isnt usefull for their situation

    ReplyDelete