Problems with SQL Srv. Agent and Proxy Account

Jakob Persson

unread,

May 17, 2002, 8:11:14 AM5/17/02

to

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

Sue Hoegemeier

unread,

May 17, 2002, 9:50:23 AM5/17/02

to

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

>Mćrsk Data AS
>Denmark

Jakob Persson

unread,

May 17, 2002, 10:22:09 AM5/17/02

to

Hi Sue

thank you for your answer.

It should allready be a member of the administrators on
the local computer - I have checked and re-checked.

I have tried with both the sa account and with Use Windows
Authentication on the SQL Server AGent Connection tab. But
alas still the same result.

Any other ideas? (I'm desperate....)

kind regards

jakob

>>Mærsk Data AS
>>Denmark
>
>.
>

Sue Hoegemeier

unread,

May 17, 2002, 11:47:52 AM5/17/02

to

You need to go to the General Tab of the SQL Server Agent
Properties window. This is where you set the service startup
account for Agent.

-Sue

On Fri, 17 May 2002 07:22:09 -0700, "Jakob Persson"

Sue Hoegemeier

unread,

May 20, 2002, 2:00:33 PM5/20/02

to

If you are following all the steps on resetting the
accounts, the only other problem I can think of that you may
be running into is if your SQL Server is installed on a
domain controller.

-Sue

On Mon, 20 May 2002 01:51:19 -0700, Jakob Persson
<jakobp...@yahoo.dk> wrote:

>Hi Sue
>
>Thank you for your answer.
>
>But again I am sorry to say - that this part is configured allready too.
>
>I can start the SQL Server Agent and run jobs okay, but I still get the
>error message regarding this Proxy account (which I have tried to
>reset, but alas no cure)
>
>Kind Regards
>
>Jakob Persson
>Maersk Data AS
>Denmark
>
>
>
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!

Michael

unread,

Jan 27, 2017, 10:04:41 AM1/27/17

to

Please assist

I am getting the below type of error message for all jobs that uses proxy account. These jobs runs fine before with the same proxy account.

Executed as user : Domain\Account.

The process could not be created for step Step Number of job Unique Job ID (reason: A required privilege is not held by the client). The step failed.

I have tried the below resolution with no luck

https://support.microsoft.com/ en-gb/help/911305/sql-server- agent-jobs-may-fail-after-you- change-the-sql-server-agent- service-startup-account-by- using-the-windows-service- control-manager