Results 1 to 3 of 3

Thread: SQLAgentCmdExec

  1. #1
    Join Date
    Aug 2003
    Posts
    5

    Unanswered: SQLAgentCmdExec

    Hi All,
    We are under the process of migrating SQLservers from Domain XX to Domain YY. Hence the startup account is changed to YY.sqlservice account etc., Everything runs smoothly except that iam getting the following error message in SQLAgent Errlog. It doesn't affects anything as of now. But still, how to avoid the following error. I appreciate your suggestions..

    Error:
    [000] Password verification of the 'SQLAgentCmdExec' proxy account failed (reason: A required privilege is not held by the client)


    Thankyou,
    Deb.

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Straight from the BOL

    To reset SQLAgentCmdExec permissions

    Expand a server group, and then expand a server.


    Expand Management, right-click SQL Server Agent, and then click Properties.


    Click the Job System tab.


    Under Non-SysAdmin job step proxy account, clear the Only users with SysAdmin privileges can execute CmdExe and ActiveScripting job steps check box, and click Reset Proxy Account.


    Type the user name, password, and domain of the user account to be used by SQL Server Agent when running jobs owned by users who are not system administrators.

  3. #3
    Join Date
    Aug 2003
    Posts
    5
    Itz applicable only to SQL2000, How to avoid this error in SQL 7.0???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •