proxy account

When a DB owner run a SQL job, the result is
"Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account.  The step failed."

what needs to be done to qualify this user to be able to run the job?

Who is Participating?
valkyrie_ncConnect With a Mentor Commented:
You have a few options, depending on your corporate security structure and rules:

1.  Add the user to the sysadmin group.
2.  Create a group that has execute permissions and assign the user to that group.
3.  Set up the job steps to execute as a user who does have sysadmin privileges, or change the owner of the job to such a user.
4.  Create a proxy and give the proxy ownership of the job.


Racim BOUDJAKDJIConnect With a Mentor Database Architect - Dba - Data ScientistCommented:
You must determine the account that runs the DTS package and create a proxy cmdshell account for that account.  Make also sure that the account has the right credential to access any folder accessed by the DTS package.

Hope this helps...
anushahannaAuthor Commented:
Thanks very much.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.