Share via

Database X on server Y is not currently available.

javier 946 Reputation points
2020-12-28T15:50:43.387+00:00

Hi, I'm getting this message everyday, in my first attempt to connect to the SQL database (either using the Query Editor (Perview) or from my app):

Database 'digital-suplai' on server 'digital-suplai' is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the session tracing ID of '{58B8F6FE-4F5E-4480-823B-D526718E5076}'.

Since seems to me that follows a pattern (I get this message after a few hours of db inactivity) I was wondering whether this was something that can be fixed or should I stick only to a retry approach as outlined in https://learn.microsoft.com/es-es/azure/azure-sql/database/troubleshoot-common-connectivity-issues?WT.mc_id=Portal-Microsoft_Azure_Support#retry-logic-for-transient-errors

thanks

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 34,676 Reputation points MVP Volunteer Moderator
    2020-12-28T17:16:38.087+00:00

    Please make sure your application can handle transient failures. Please take a look at this article.

    Sometimes that error comes as result of intermittent login failures on specific regions as you can read in this thread. Make sure Azure (here) is not reporting any issues on the region where the database is located. Examine also Resource Health on Azure Portal. It is located on the left vertical panel related to your Azure SQL database.

    51741-resource-health.png

    1 person found this answer helpful.
    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.