Note If you have version 12.0.4050.0 of SQL Server 2014 Service SP1 (KB3018269) installed, you must uninstall that update from all installation instances before you install this update. To do this, use Add or Remove Programs in Control Panel. For more information, see KB 3018269. Be aware that you may have KB3018269 installed for any of the following reasons:

  • You applied the update to an existing instance of SQL Server 2014.

  • You installed a new instance of SQL Server 2014 SP1 by using the KB3018269 “Slipstream Package” (for example, SQLServer2014SP1-FullSlipstream-x64-ENU).

  • You installed any of the SQL Server 2014 SP1 Express Edition packages.

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

Note The instance is then in an invalid and unusable state.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Resolution

To resolve this issue, follow these steps:

  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).

References

For more information about this issue, see SQL Server 2014 Service Pack 1 has released.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.