October 3, 2011 at 8:37 am
I have a named instance that is scheduled to reboot once a month. The Start Mode is set to 'Automatic' in the SQL Server Configuration Manager.
The Agent failed to start after the reboot. However, the agent did restart on a different named instance.
Here is the output from the logs:
SQL Server Agent Log:
2011-10-01 01:02:46 - ! [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started)
2011-10-01 01:04:46 - ? [098] SQLServerAgent terminated (normally)
Event Log:
2011-10-01 01:02:44 AM Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
2011-10-01 01:02:44 AM Report Server Windows Service (PROD) cannot connect to the report server database.
SQL Error Log:
2011-10-01 01:04:45.53 spid51 Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
This has happened once or twice before. Can anyone tell me how to prevent this from happening again?
October 3, 2011 at 8:55 am
Patrick Womack (10/3/2011)
I have a named instance that is scheduled to reboot once a month.
May I ask why?
Can anyone tell me how to prevent this from happening again?
Looks like the Windows EventLog was not available. Try setting the Recovery action to "Restart the service" in the service properties, Recovery tab.
-- Gianluca Sartori
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply