SQL Server Agent jobs fails, permission denied

Problem

SQL Server agent jobs fail with the following message: “Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account” even though both the job owner, current user and agent user are members of the sysadmin role.

SNAGHTML16831ef

Workaround

  • Change the job owner to sa.
  • Or if it is a part of a maintenance plan, change the plan owner. See https://lokna.no/?p=325
  • Define a proxy account.

solution

Make sure the job owner is a direct member of the sysadmin role. If the sysadmin role membership is granted to an AD group, you get the error mentioned above when you try to run jobs who require sysadmin membership.

Author: DizzyBadger

SQL Server DBA, Cluster expert, Principal Analyst

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.