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

Back in June 2014, I discovered a SQL Server 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 🙂

Page 2 of 1112345...10...Last »
CJayMead's SQL Server, Endeca, MS Office Help © 2016