MSSQL 2008 SP1 Install - Server is in script upgrade mode. Only administrator can connect at this time

After taking the usual database backups etc. I went to install SP1 on a SQL 2008 server (RTM)
following the normal routine of stopping the sql server services and firing up the service pack install.

All went fine, and the service pack finished. Anyway I rebooted the server to check everything was clean on startup.

When the server came back I checked the eventlog, and that the services started fine etc.
Next I used management studio to connect to the server only to get the message
'Server is in script upgrade mode. Only administrator can connect at this time.'

Firstly I checked the sql log file and the event log - nothing to say why.
Hence while I searched the web for this message and found a MS connect article

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=416860

It turns out that the upgrade scripts run on the first startup, hence the message.
Once the scripts have completed (which took a while), evertthing was sorted and normal access restored.

 

 

Published 25 June 2009 12:40 by StevenWhite
Filed under:

Comments

# Upgrading SQL Server 2008 Trial Version to Developer Edition » Dave Turpin, SQL Server Professional

Pingback from  Upgrading SQL Server 2008 Trial Version to Developer Edition »  Dave Turpin, SQL Server Professional