Hi,

Posting again with a little detail. (with answers to Mr. Russell Fields)
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.
SQL Server Agent service is using the same login that is being used by SQL
Server, using Local System for both.
SQL Server's clock is synced with the domain controller's.

Find below the SQLAGENT.OUT file text:

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)

M K

Here is a lengthy thread on the error you are getting. For these users it
was a DNS problem. JPOPP seems to be the one who understands, so look to
his responses and what follows.
http://forums.windowsitpro.com/web/f...VIEWTMP=Linear

Also, running as Local System is not a best practice, both because of its
power on the server and its limitations on the domain. The best practice is
to define a domain login, grant it appropriate rights on the server and on
the domain, and use it to run SQL Server and SQL Agent. See:
http://www.sqlservercentral.com/arti...accounts/2351/

RLF

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