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

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

more ▼

asked Dec 11, 2012 at 08:00 AM in Default

askmlx121 gravatar image

2.5k 67 74 77

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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

answered Dec 11, 2012 at 10:34 AM

anthony.green gravatar image

1.2k 4

hi anthony, green my account had already sysadmin permission. but i dont know proxy account whether is it or not. how to set this????????
Dec 11, 2012 at 10:51 AM askmlx121

Check the privledges of the account which the agent is running under.

This link will help on creating proxy accounts Proxy Accounts

Dec 11, 2012 at 11:22 AM anthony.green
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 11, 2012 at 08:00 AM

Seen: 3117 times

Last Updated: Dec 11, 2012 at 11:37 AM