HI,

Whenever my Server Machine (Windows 2008 Server) restarts. My SQL Server
2008 DB engine & every thing starts normally. But the SQLSERVER AGENT
(Configured to be Automatic) do not starts & I have to start it Manually by
right click & start it through Management Studio.

The message in Windows log is:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).


Seems no problem of SYSTEM ACCOUNT unable to start. In that case, it must
not have allowed the Manual Start of SQL Server then. Maybe SQLServer agent
trying to start before start of MS SQLSERVER.

Any idea?

M.K (mianksaeed (AT) yahoo (DOT) com) writes:
You could try to configure it to start "Automatic (delayed)"


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Tried with "Automatic(delayed)" but didn't worked.
Below is the text of SQLAGENT.OUT file:-

2009-08-06 21:50:16 - ! [298] SQLServer Error: 848, SQL Server Network
Interfaces: The system detected a possible attempt to compromise security.
Please ensure that you can contact the server that authenticated you.
[SQLSTATE HY000]
2009-08-06 21:50:16 - ! [298] SQLServer Error: 848, Cannot generate SSPI
context [SQLSTATE HY000]
2009-08-06 21:50:16 - ! [000] Unable to connect to server '(local)';
SQLServerAgent cannot start
2009-08-06 21:50:16 - ! [298] SQLServer Error: 848, SQL Server Network
Interfaces: The system detected a possible attempt to compromise security.
Please ensure that you can contact the server that authenticated you.
[SQLSTATE HY000]
2009-08-06 21:50:16 - ! [298] SQLServer Error: 848, Cannot generate SSPI
context [SQLSTATE HY000]
2009-08-06 21:50:16 - ! [382] Logon to server '(local)' failed
(DisableAgentXPs)
2009-08-06 21:50:17 - ? [098] SQLServerAgent terminated (normally)





"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

M.K,

The core problem is that it cannot (at that time at least) generate the SSPI
context.

Questions: Are you running SQL Server Agent service using the same login
that you use for SQL Server? Are you using Local System for either? At
startup, is the SQL Server's clock out of synch with the domain controllers?
etc.

Here is a Microsoft document on troubleshooting this problem.
http://support.microsoft.com/kb/811889

Here is a SQL Server Central article from a few years ago (SQL Server 2000)
that several people have found helpful, including resolving the SQL Agent
problems. Be sure to follow the "Join the discussion" link to read the
experiences posted.
http://www.sqlservercentral.com/arti...picontext/929/

Hope that helps,
RLF

"M.K" <mianksaeed (AT) yahoo (DOT) com> wrote

Thanks for help. Will look at the links you sent for troubleshoot the issue
& would try the solution.


"Russell Fields" <russellfields (AT) nomail (DOT) com> wrote