Right to access SQL Server Integration services

Posted on 2014-08-24
Last Modified: 2014-08-25
A local administrator granted to SQL Server 2008 R2 can access Database service but can't connect to Integration Services on the local server. What access right should I grant to the administrator in order to access the Integration service ?

Question by:AXISHK
    LVL 18

    Assisted Solution

    grant them "local access":

    Run Dcomcnfg.exe. In the Component Services dialog, expand the Component Services > Computers > My Computer > DCOM Config node.
    Right-click MsDtsServer100, and then click Properties.
    On the Security tab, click Edit in the Launch and Activation Permissions area.
    Add users and assign appropriate permissions, and then click Ok.
    Repeat steps 4 - 5 for Access Permissions.
    Restart SQL Server Management Studio.
    Restart the Integration Services Service.
    LVL 16

    Accepted Solution

    Microsoft documentation defines the SSIS - specific roles here. Review these and decide what your local admin should have (does she or he really need ssisadmin, for example), and then grant membership of the appropriate role.



    Author Comment

    Where can I grant the role ? Tks

    Author Closing Comment


    Author Comment

    Finally sort the the problem, Ts

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now