This post has been wikified, any user with enough reputation can edit it.
asked
Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account?
My organization DBA person has left from company. He was created the 5 jobs.I am a new dba i have a sysadmin role but last week we faced the non logged agent shutedown error in one snapshot replication job . so i logged in and reinitilized the subscription in my login. then runs the job it suceeceds. but my problem is next week previous DBA created 4 jobs and replication snapshot 1 jobs totally 5 jobs are throw the error as **Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account**. ![alt text][1] Above Error came for following failed job list:(All of the jobs created by previous dba and executed by me) Weekly log file shrink Weekly index rebuild Weekly statistics update Weekly log file shrink one db Live machine one db copy to Dev machine Live machine one db snapshot to Dev machine what is the solution??? [1]: /storage/temp/518-snapshot+replication+non+sys+admin+error.jpg
You need to add your account in as a sysadmin, and or create a proxy account which has the correct permissions and tell the jobs to run via the proxy account instead of the calling user. The issue boils down to the fact that your account is not privledged enough to run the jobs in question.
Check the privledges of the account which the agent is running under. This link will help on creating proxy accounts [Proxy Accounts][1] [1]:
http://msdn.microsoft.com/en-us/library/ms190698%28v=sql.105%29.aspx
10 People are following this question.
