|Message:||The MSSQLServer service terminated unexpectedly. Check the SQL Server error log and Windows System and Application event logs for possible causes.|
The SQL Server service terminated unexpectedly.
Examine the error logs to figure out what caused the SQL Server service to terminate.
|Message:||The MSSQLServer service terminated unexpectedly.|
|The error is reported by the SQL Server Agent service when it auto restarts SQL Server. SQL Server Agent will only auto restart SQL Server if SQL Server stopped for some reason other than an explicit stop command from a user or application, and if the Auto restart SQL Server if it stops unexpectedly option is selected in SQL Server Agent Advanced properties. During the restart of SQL Server, SQL Server Agent will write this message to the application event log on the computer hosting SQL Server.
SQL Server can stop unexpectedly from several different causes. Those causes include:
|If you do not want SQL Server Agent to automatically restart SQL Server, turn off the option. The procedure for this is described in “SQL Server Agent Properties (Advanced Tab)” in Books Online.
If the problem occurs repeatedly, you will need to determine why the SQL Server service unexpectedly stopped: