If you receive a message that a SQL Server service failed to start, to troubleshoot the issue check the following:
- Determine the error. A message would either be shown in the UI or in the summary.txt log located at
%programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log
. - Verify if the type of startup service is automatic or manual.
- Verify that the account and password is valid and has not expired. A service could have been running previously with an invalid account or password.
- If the Database engine service will not start, after checking service credentials and startup, check the ERRORLOG. The ERRORLOG can be located at
C:\Program Files\Microsoft SQL Server\<Instance ID>\MSSQL\LOG
.
Refer to this article: SQL Server service may not start after patch installed
Also, check the Windows firewall.
Best regards,
Cosmog Hong
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.