What does "Can not connect to the database in its current state" mean and how can I correct?

Jim 26 Reputation points
2021-10-25T18:16:44.857+00:00

I have recently started receiving "Can not connect to the database in its current state." when trying to connect to my Azure SQL database - as far as I know nothing has changed and I get the same error using the query tool in the azure portal ( using either AD auth or SQL auth ).
I cant see any way of "restarting" the sql instance or what might be wrong - does anyone know how I can either raise a support ticket or get this resolved?

Further info.
The status of the database is "online"
When I run the troubleshooter it says no issues were found.

Azure SQL Database
0 comments
Accepted answer
  1. KalyanChanumolu-MSFT 8,316 Reputation points
    2021-10-26T04:32:10.993+00:00

    @Jim Thank you for reaching out.

    This usually indicates you may have hit a pricing/budget limit on your subscription/resource.
    Please reach out to your billing administrator to check if any budget restrictions were applied to this resource.

    If it is still not resolved, please reach out to Azure Support and submit this as a "Billing Issue". You don't need a support plan for billing issues.

    ----------

    If an answer is helpful, please click on 130616-image.png or upvote 130671-image.png which might help other community members reading this thread.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 32,806 Reputation points MVP
    2021-10-26T03:13:23.033+00:00

    Are you using Key Vault with Azure SQL Database? Make sure permissions to the key vault are properly set.

    Another possible reason may be the database may be in recovery state. In that case you may have to create a support ticket here.