June 24, 2014 at 2:28 am
Hi all, I am having trouble trying to figure out how to get SQL Agent service to automatically start on a reboot.
The service is set to automatic and the log on is Local System Account (I know not best practice and will deal with).
Once SQL is running the agent starts quite happily. It seems just on restart it fails.
Here are the four errors from the agent log on restart:
[382] Logon to server '(local)' failed (DisableAgentXPs)
[298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
[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]
[000] Unable to connect to server '(local)'; SQLServerAgent cannot start
Any help would be gratefully accepted.
Scott
June 24, 2014 at 6:26 am
I would first have the SQL Agent run as a domain account so you have control of it's permissions. I think it'll behave well if you set the start up type of "Automatic (Delayed Start)".
June 27, 2014 at 10:41 am
Great. Will give that a try and report back
many thanks
Scott
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply