Post reply

How to allow a non sysadmin to run a DTSX package

  • January 26, 2012 at 3:24 pm

    #267219

    I would like to allow a user to create, edit and execute their own DTSX packages on one of our servers. I was hoping I could do this by adding them to the SQLAgentOperatorRole. I tried this and they get an error:

    Message

    Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. The step failed.

    Do I need to set up a Proxy account? If so, can you point me in the direction of a good guide... I have never created a Proxy account and would appreciate all the help I can get if this is the only solution.

  • January 26, 2012 at 8:04 pm

    #1439117

    IIRC, the proxy account will only help folks when it comes to running a job. It won't help them with creating or editing a job.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • January 27, 2012 at 12:11 am

    #1439164

    An overview of the SSIS security roles:

    Using Integration Services Roles

    Agent security roles:

    SQL Server Agent Fixed Database Roles

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply