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.
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.