RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.
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:
· 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
MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, RELIABILITY OR ACCURACY OF THE INFORMATION CONTAINED IN THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED ON THIS WEBSITE (THE “MATERIALS”) FOR ANY PURPOSE. THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE.
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.
Microsoft SQL Server 2008 Express, Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 Developer, Microsoft SQL Server 2008 Web, Microsoft SQL Server 2008 Standard, Microsoft SQL Server 2008 Standard Edition for Small Business, Microsoft SQL Server 2008 Analysis Services, Microsoft SQL Server 2008 Express with Advanced Services, Microsoft SQL Server 2008 Reporting Services