SQL SERVER – Login Failed For User – Reason Server is in Script Upgrade Mode

I just can’t get enough of the error messages that land into my Inbox almost every single day. I do my due diligence of making a search in my blogs and I try to hang around in the forums from time to time to learn what people are getting as errors. While browsing through forums, I have been able to find that this error was faced by many users. It is one of the most common errors that seem to land, let me know if you ever faced the following error in your environments:

Login failed for user ‘MyDomain\Username. Reason: Server is in script upgrade mode. Only administrator can connect at this time. (.Net SqlClient Data Provider)

Solarwinds

I did some more research and found below facts:

  • Whenever any SQL Server patch is applied, setup would patch the binaries first.
  • During the restart of instance, SQL Server startup would go though “script upgrade mode” during recovery phase.
  • Script upgrade mode is the phase where objects inside the databases are upgraded based on recently patch applied.
  • Based on features installed and number of databases available, it would take varying amount of time.

The best way to look at the upgrade script status is to keep observing ERRORLOG continuously. Since we would be not able to connect to SQL via SSMS or client tools, we need to open ERRORLOG via windows explorer by going to physical location. Once “Recovery is complete” message is printed in ERRORLOG, we should not see the message any further.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
Previous Post
SQL SERVER – The Basics of the File System Task – Part 2 – Notes from the Field #075
Next Post
SQL SERVER – CONCAT function and NULL values

Related Posts

4 Comments. Leave new

  • We use to get this issue everytime our SQL Server cluster failover. After a long and painful investigation we found that the two sql instance are on different patches. Had to failover back everytime until the patching was resolved.

    Reply
    • That’s a very valid scenario. Whenever there is a version difference between binaries and database, SQL Sever does a script upgrade (even if its a downgrade)

      Reply
  • WHERE I can download cheapest XRumer + BlogsPlugin?

    It is really new powerful tool for SEO, I’m want it, so help me please if it possible… Thnk!
    At most I need BlogsPlugin – it’s automate blogging with captchas bypass and works with a TOP-10 Blogs platforms…
    (it’s included in XRumer 12 official package, so please help me to find it! Thank you again!)

    Reply
  • Thanks, its get solved automatically after some time as you said.

    Reply

Leave a Reply

Menu