Share via

Login failed for user 'your_username'. Reason: Server is in script upgrade mode."

ken 0 Reputation points
2024-01-24T21:42:31.5633333+00:00

I'm trying to connect to my Azure SQL Database, but I keep getting this error: "Login failed for user 'your_username'. Reason: Server is in script upgrade mode." Anyone ever encountered this? What's thiss script upgrade mode, and how can I get past this?

Azure SQL Database
SQL Server | Other

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Azar 29,520 Reputation points MVP Volunteer Moderator
    2024-01-24T22:05:53.6566667+00:00

    Hey there! ken So, the "Server is in script upgrade mode" error usually pops up during a SQL Server upgrade. When you connect to your database during this upgrade process, The best approach is to wait patiently. SQL Server is probably in the middle of applying changes or running scripts. Once the upgrade is complete, you should be good to go. If you're still stuck after a reasonable amount of time, check the Azure portal for any ongoing maintenance or issues. If all seems clear, try reconnecting a bit later. also make sure you have the latest SQL Server Management Studio (SSMS) version. Sometimes, an outdated SSMS can play the spoilsport. If this helps kindly accept the answer thanks

  2. SSingh-MSFT 16,371 Reputation points Moderator
    2024-01-25T07:04:48.91+00:00

    Hi
    ken     •,

    Welcome to Micrsoft Q&A forum.

    As I understand, you are unable to connect to Azure SQL Database and getting error: Login failed for user 'your_username'. Reason: Server is in script upgrade mode."

    This error is transient and should be solved after some minutes when upgrade is complete.

    Please retry and let us know if you are still facing this issue so that we can investigate further.

    Thanks

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.