DTS and SQL server agent security

#1

Does anybody familiar with the message "SQLServerAgent
Security context does not have server-autorestart
privilege." and " password verification of
the 'SQLAgentCmd Exec' proxy account failed(reason: A
required privilege is not held by the client).
When I run the jobs(DTS, maintenance), I got this error
messages above. In fact, I used my account to start the
agent and I am the local admin.
Any idea would helpful.

#2

Are you experiencing this ?

http://support.microsoft.com/default...ticle%3D295670

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Tracy Yang" <tyang (AT) nas (DOT) edu> wrote

Quote:

Does anybody familiar with the message "SQLServerAgent
Security context does not have server-autorestart
privilege." and " password verification of
the 'SQLAgentCmd Exec' proxy account failed(reason: A
required privilege is not held by the client).
When I run the jobs(DTS, maintenance), I got this error
messages above. In fact, I used my account to start the
agent and I am the local admin.
Any idea would helpful.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS and SQL server agent security

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS and SQL server agent security - 12-03-2003 , 03:19 PM

Re: DTS and SQL server agent security - 12-04-2003 , 01:08 AM