Re: Problems with SQL Srv. Agent and Proxy Account

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 05/17/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Fri, 17 May 2002 07:50:23 -0600

SQL Server Agent account can't use sa - it needs to use a
Windows Account.
If SVC_SQLAGENT is the domain account you want to use for
SQL Server Agent, try adding this account to the local
admins group on your SQL Server PC and make sure the Account
referenced for SQL Agent is SVC_SQLAGENT, not sa.

-Sue

On Fri, 17 May 2002 05:11:14 -0700, "Jakob Persson"
<jakobpersson@yahoo.dk> wrote:

>Hi
>
>On SQL Server 7.0 SP3 Std. Edt installations (and a single
>7.0 SP3 Desktop Edt.)
>
>I have made an domian user account SVC_SQLAGENT (with user
>rights recording to INF: Reset Proxy and the
>SQLAgentCmdExec Account (Q264155))
>
>I get this error when starting the SQL Server Agent:
>
>[000] Password verification of the 'SQLAgentCmdExec' proxy
>account failed (reason: A required privilege is not held
>by the client)
>
>The agent starts, I can execute the jobs I have configured
>(maintenance and backup) ,but I still need to setup
>replication on the server - and I am not happy with this
>message.
>
>I have tried to:
>- both reset the Proxy account and Proxy Password of
>the "SQLAgentCmdExec" on the Job system tab of the SQL
>Agent properties
>
>- Set my sa user as the account that the SQL Server Agent
>should use to connect to the SQL Server
>
>- Re-entered the pwd for the SQL Server Agent user acount
>
>- Stopped and Started the SQL Agent sercive
>
>What have I done wrong?
>
>What to do to avoid this error?
>
>Thank you
>
>Jakob Persson
>Mærsk Data AS
>Denmark

Relevant Pages

  • Problems with SQL Srv. Agent and Proxy Account
    ... I have made an domian user account SVC_SQLAGENT (with user ... I get this error when starting the SQL Server Agent: ... Password verification of the 'SQLAgentCmdExec' proxy ...
    (microsoft.public.sqlserver.security)
  • Re: Browsing for Publication error message
    ... what is going on with the description you gave previously but I would guess that the subscriber SQL Server Agent service account was somehow added to the publication access list of the publication on the DMZ. ... select from the MSpublication_access table in the distribution database and see if the account for your Subscriber's SQL Server Agent service account shows up. ...
    (microsoft.public.sqlserver.replication)
  • Re: Re-installing SP4
    ... > I will try unregistering the components with the service account but what ... >> guessing that you want a cleaner approach so you are wondering if an SP4 ... >> 1) SP4 setup could not retrieve information for the SQL Server Agent ... >> privilege to enumerate the Agent service account information. ...
    (microsoft.public.sqlserver.replication)
  • SQL Server Agent Proxy Account Setup Problems
    ... I am trying to create a Proxy SQL Server Agent windows ... Account for Non SA Users to execute Jobs like Active X ... Sysadmin Job Step Proxy Account Check Box to enable non sa ...
    (microsoft.public.sqlserver.security)
  • Re: Distributor SQLSERVERAgent Account
    ... your subscriber's sql server agent should be running ... under the same account as the publisher's SQL Server agent, ... that is part of the local admin group on the publisher. ... If this is not possible the SQL Server agent account on the subscriber ...
    (microsoft.public.sqlserver.replication)