admin

Sep 062011
 

After a install Service Pack 1 on a Microsoft SQL 2008 R2 server, I received the following error when trying to Connect to the Server with Microsoft SQL Server Management Studio. Login failed for user ….. Reason: Server is in a script upgrade mode

 

 

 

 

 

Looking at the Application Event View, the following error was found:

Source: MSSQLSERVER

Event ID: 912

Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’ encountered error 598, state 1, 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 errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.

SOLUTION:

Before the installation:

Ensure the Database default locations point to the folder where your system databases reside.


After the installation:

Shutdown all SQL services

Started Registry Editor

Navigate to: HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQLSERVER

Ensure DefaultData and Default Log point to the directories that the System databases reside:

Start the SQL Services that you shutdown, you’ll have to wait a few minutes for all the scripts to run to complete the upgrade [If you go into the Management Studio, you’ll receive the same error you received, no fret, just wait some more, I’d say around 15min.]

 

 

 

Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’ encountered error 598, state 1, 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 errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.

 Posted by at 11:38 am