question

askmlx121 avatar image
askmlx121 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
replicationsnapshot
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
anthony.green avatar image
anthony.green answered
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.
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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
1 Like 1 ·
hi anthony, green my account had already sysadmin permission. but i dont know proxy account whether is it or not. how to set this????????
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.