In SSMS can I add a DB user to the SQLAgentUserRole role?


  • I need to assign a specific owner to a job.  I created a new login and assigned it to be the owner of the job.  When I run the job 

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

    Is there a way in SSMS I can add the user that this login is mapped to with the SQLAgentUserRole role?

    Thursday, November 21, 2013 8:44 PM


All replies