SQLAGENTSERVER startup!

SQL Server 2000 + SP4 .

Sql Server service , startup manual, Startup account : Local System
I can start the service, the client application can connect, everything is
OK.

SqlAgentServer, startup : manual, Startup account: Local System.
When I start the server Agent manually it stops immediately.
In the Application event log I have:
1. Error: "SQLServerAgent could not be started (reason: Unable to
connect to server '(local)'; SQLServerAgent cannot start)."
2. Information: "SQLServerAgent service successfully stopped."

In the ...Management->Sql Server Agent/ Display Error Log I have 2 error
messages:
1. "[165] ODBC Error: 0, Cannot generate SSPI context [SQLSTATE
HY000] "
2. "[000] Unable to connect to server '(local)'; SQLServerAgent
cannot start"

If I change the Startup account to a Local Administrator the server agent
service starts without any problems.


Any ideas why don't start my service with the Local System account.



.

Relevant Pages

  • Re: SQLAGENTSERVER startup!
    ... Did you delete BULTIN/Administrator Logim in SQL Server or removed it from ... SqlAgentServer, startup: manual, Startup account: Local System. ...
    (microsoft.public.sqlserver.security)
  • Re: SQLAGENTSERVER startup!
    ... Because I use this server for testing, ... There is only one instance of SqlServer installed on my PC, ... SqlAgentServer, startup: manual, Startup account: Local System. ...
    (microsoft.public.sqlserver.security)
  • Re: SQLAGENTSERVER startup!
    ... This account is under Security -> Logins and is all right, ... Did you delete BULTIN/Administrator Logim in SQL Server or removed it from ... SqlAgentServer, startup: manual, Startup account: Local System. ...
    (microsoft.public.sqlserver.security)
  • WMI works except process create (urgent)
    ... A service running under the Local System account is failing to create a ... The same program works on another W2K3 server as well as on many W2K ... I've compared DCOM an WMI Control security settings to other ... admin) other than Local System. ...
    (microsoft.public.win32.programmer.wmi)
  • Re: SBS Monitoring Issues
    ... should be configured to run as Local System. ... Microsoft Small Business Server Support ... SBS 2000: microsoft.public.backoffice.smallbiz2000 ... > SQLServerAgent must be able to connect to SQLServer as ...
    (microsoft.public.windows.server.sbs)