SQL Server 2012 SP1 CU1 installation failure + Instance will no longer start - by PatrickPurviance

Status : 

 


8
0
Sign in
to vote
ID 775401 Comments
Status Active Workarounds
Type Bug Repros 1
Opened 12/28/2012 12:13:27 PM
Access Restriction Public

Description

When attempting to apply SP1 CU1 to SQL Server 2012 Enterpise 64bit, the CU installation fails to update the following Features:

Data Quality Services
Full-Text and Semantic Extractions for Search
SQL Server Replication
Database Engine Services

To make matters worse, as a direct result of the last feature upgrade failure, the SQL Server instance itself will no longer start due to permissions failures regarding scripts that must be run against the master database prior to startup post update application.

The following is found in the SQL Server Error logs for the subsequent service start attempts:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Script level upgrade for database 'master' failed because upgrade step 'u_tables.sql' encountered error 25641, state 0, severity 16. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

A workaround has been found and documented in this Connect Feedback, but this situation could occur rather frequently for anyone installing SQL Server using the default settings (typical for developer or end user installations where no DBA supports the environment) and then later wants to apply service packs and cumulative updates.  Essentially the user is painted into a corner that renders their SQL Server Database Engine unusable because it will not start under these conditions.
Sign in to post a comment.
Posted by RobNicholson, MCSM on 9/16/2013 at 8:51 PM
This happens on 2012 SP1 CU5 as well.