SqlServer is in script upgrade mode

Lieven_Cardoen_26521 0
Viewed 48194

Vista just finished one of its many updates. After restarting my computer I try connecting to SqlServer2008 instance with Sql Server Management Studio and I get this error:

Error connecting to '...\MSSQLSERVER2008'. Additional information: Login failed for user '...'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. (Microsoft SQL Server, Error: 18401).

Pressing help gets me to an internet page saying there's no additional information.

Thx Vista & Updates. Anyone an idea because on the internet I can't find anything about this issue.

sql-server-2008 sql-server
6 Answers

It appears This Guy was having the same problems as you and his only suggestion was to wait a few minutes before trying to log in again.

I have yet to see any type of Microsoft documentation about this, nor have I seen any forum posts which came to any sort of resolution concerning the same problem.

TheTXI_221640

The Reason for this is that the system reboot happens with important\necesssary softwares loaded and does all other operation later so that the booting happens faster.

Here in your case, the sql booting is happening as the start of SQL is not needed for system to start. I hope you are aware of DAC account(Dedicated Administrator Connection, Link) who has seperate connectivity and has ability to resolve issues even the whole SQL server is not responing. The SQL server is asking you either to wait or open the SQL with DAC account and stop the SQL update.

Solutions:

1) Wait until backround update completes

2) Open SQL using DAC account and kill all running processes

user_43376020
Related