-
SQL Job Execution rights
I have a SQL 7.0 server which has a SQL job which includes a step to run a DTS package. The step uses the CmdExec and DTSRun to run the package.
I need to allow a non-sa user (userX)access to run the SQL job.
When I set the job owner to userX, the user can see the job and execute it but it fails with a message:
Password verification of the 'SQLAgentCmdExec' proxy account failed (reason: A required privilege is not held by the client).
How can I configure the SQL job so that userX can run it successfully??
Thanks.
-
Try reset password for SQLAgentCmdExec in sql agent properties.
-
SQL Job Execution rights
I have reset the password in SQL Agent. But I am still getting the following error in my SQL Agent error log
on startup:
[000] Password verification of the 'SQLAgentCmdExec' proxy
account failed (reason: A required privilege is not held
by the client)
Does the password have to be something special. SQL Agent does not let me set the password it just "resets" it.
-
Go to sql agent properties -> job system in em and ensure the box besides 'only users with sysadmin ...' is unchecked.
-
Turns out it was a problem with the account that was configured to run SQL Server and SQL Agent not having the appropriate permissions on the local box.
Permissions needed -
MSSQLServer and SQLServerAgent Services:
Act as part of the Operating System.
Increase Quotas.
Replace a process level token.
Log on as a batch job.
SQLAgentCmdExec Account:
Log on as a batch job
Once we changed the permissions and restarted SQL Agent everything worked fine. Thanks for your help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|