Results 1 to 5 of 5

Thread: SQL Job Execution rights

  1. #1
    Join Date
    Sep 2002
    Posts
    41

    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.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Try reset password for SQLAgentCmdExec in sql agent properties.

  3. #3
    Join Date
    Sep 2002
    Posts
    41

    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.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Go to sql agent properties -> job system in em and ensure the box besides 'only users with sysadmin ...' is unchecked.

  5. #5
    Join Date
    Sep 2002
    Posts
    41
    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
  •