Friday, May 15, 2015

SQL Server 2014 Service Pack 1 "Re-released"

After few weeks of the "release and revoke" of SQL Server 2014 SP1 , we have a new version available for download. Test it carefully this time.

The original version raised an error if the instance had a SSIS catalog 

Symptoms

Assume that you have a SQL Server instance that has the SSISDB catalog enabled in Microsoft SQL Server 2014. When you try to upgrade to SQL Server Service Pack 1 (SP1) build number 12.0.4050.0, you receive the following error messages:

Error: 912, Severity: 21, State: 2.

Script level upgrade for database 'master' failed because upgrade step 'SSIS_hotfix_install.sql' encountered error 3602, state 251, severity 25. 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 error log entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.


Error: 3417, Severity: 21, State: 3.

Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online. SQL Server shutdown has been initiated




Here is the installation procedure if you already installed the SP 1 build 12.0.4050.0
  1. Use Add or Remove Programs in Control Panel to uninstall version 12.0.4050.0 of SQL Server 2014 SP1 (KB3018269).
  2. Install SQL Server 2014 SP1 version 12.0.4100.1 (version 12.0.4100.1).

Error 912 or 3417 when you install SQL Server 2014 SP1 (build 12.0.4050.0)


SQL Server 2014 Service Pack 1 release information




Text-to-speech function is limited to 100 characters

No comments:

Post a Comment