none
Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. RRS feed

  • Question

  • First of all, I am a sysadmin.  I am changing an agent job (which uses an SSIS package) owner to me.  When I try to run it under me as owner, it fails with the "Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account.  " error.  When I change it back to the original owner, it works.  Any ideas??
    Tuesday, December 13, 2011 6:56 PM

Answers

  • You need a domain proxy account to run the step in the Agent job that call the package.

    (just in case you may want to see http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx)


    Arthur My Blog
    • Marked as answer by Eileen Zhao Monday, December 19, 2011 4:01 PM
    Tuesday, December 13, 2011 10:09 PM
    Moderator

All replies

  • You need a domain proxy account to run the step in the Agent job that call the package.

    (just in case you may want to see http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx)


    Arthur My Blog
    • Marked as answer by Eileen Zhao Monday, December 19, 2011 4:01 PM
    Tuesday, December 13, 2011 10:09 PM
    Moderator
  • I have the same problem. 2 different sysadmin accounts cannot run the job.  Any ideas ?
    Tuesday, January 8, 2013 3:55 PM