You may receive a message that a SQL Server service has failed to start. The SQL Server fails to restart after the patch installer installs a patch and attempts to restart the system. The error message will be displayed on the screen or will appear in the Summary.txt log.
This may be caused by a SQL Service is running but the password has expired. When the patch installer tries to restart the SQL Service will fail on restart.
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
TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.
Article ID: 961301 - Last Review: Dec 17, 2008 - Revision: 1