(SQL) Server is in script upgrade mode. Only administrator can connect at this time

I got this one today on my home laptops and was beginning to panic:

Login failed for user ‘LoginName’
Reason: Server is in script upgrade  mode.
Only administrator can connect at this time.

Even worse, I am the administrator when I tried this. But a quick search of the intertubes revealed this http://www.sqldbadiaries.com/2010/12/06/server-is-in-script-upgrade-mode-only-administrator-can-connect-at-this-time/#ixzz1Z5vYOH4q.

As described there, I leave my local sql server service set to manual and do not start it until I want to use it. Windows Update must have run a Service Pack against it but, because the service was down, the T-SQL updates were delayed until first service start (i.e. now!)

Wait a minute or two, and the database is available again and the message no longer appears.

Advertisements
Leave a comment

2 Comments

  1. Great delivery. Outstanding arguments. Keep up the great
    work.

    Reply
  2. Johne176

     /  May 18, 2014

    Appreciate it for helping out, great information. deekkacbddcd

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: