Weird SQL Server Error: Unable to Connect to Server. Reason: Server is in script upgrade mode
- by Scott Whigham on April 14, 2009 1:04 PMSo I installed SQL Server 2008 SP1 on a test machine last week and, after doing other things for the past week, I came back to my SQL Server 2008 and started the service. I then tried to connect using Management Studio and, after a few seconds, I got this error:
Okay – so I read the line, “Only administrator can connect at this time” and tried connecting using a Dedicated Administrator Connection (DAC). After about 30 seconds, it came back with a generic timeout error.
Huh!?!
I was truly flummoxed. And so I did what we all would do – I tried again and again (and received the same answers).
Okay… This is getting frustrating…
Quick – to the Google Mobile!
I did manage to find one article on Microsoft Connect (but don’t bother going there): http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=431405. Some posted that this is “by design” due to the fact that the “database state and log file location being unavailable during the upgrade…”'
And so I went back to my Management Studio and tried again – and it let me in!
So… If you came here because you googled about how you couldn’t get into your SQL Server after installing a service pack, just wait a few minutes and let the upgrade complete it’s work! You’ll then be able to connect.
And, next time, Microsoft – please give us a little more helpful error message. It is April 14th here in the US, one day before taxes are due, and I’m late in filing already! I didn’t even remember that I had installed SP1 and had yet to connect lol.
Thanks! I just upgraded from Vista to Windows 7 RC and thought it was an upgrade issue. Not so, I just waited a few minutes and I'm all set.
The issue is also logged here:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=416860
Nice post. Thank you for information ! Please keep posting.
In fact, some of the Swiss luxury watch, in appearance and identity numbers are there, and done a lot of anti-counterfeiting
measures,. For example, Rolex has 5 numbers, they are: (1) case models, (2) Watch production sequence number
movement and on the number, (4) the movement and on the production sequence number, (5) the band number. In addition to the
band number in the band discount out surface, the rest are hidden, not to remove the watch strap or open the rear door in order to
see it.
I really enjoyed your blog post. Honestly, I enjoy almost all of your posts!
Thanks, I learned a lot.
Been reading through your site for a couple hours now. Lot of great posts.
"I <three y ou PENISI Wont"
I love your site.
You’re a Really Professional Blogger, You either have got top quality knowledge of what your discussing or you did some great research. Thanks for this excellent article.