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

Earlier today I discovered a SQL Agent job that was failing with the error “Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. The step failed.”

It turns out that the person who set up the job did not have sysadmin rights.

I changed the owner of the job to a sysadmin user, and now it works 🙂

Hope this works for anyone else who gets this error.

Leave a Reply

Your email address will not be published. Required fields are marked *

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

CJayMead's SQL Server, Endeca, MS Office Help © 2018