Database 'DATABASENAME' on server 'server-name' is not currently available.

Artsem Shumski 0

Hello,

I am unable to connect to Azure SQL. This has been going on for the last 48 hours.
Error:
TITLE: Microsoft SQL Server Management Studio

Database '<DBName'> on server '<server-name>' is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the session tracing ID of '{2243B91D-2CA4-4A15-AD82-B8A78CA906DA}'. (Microsoft SQL Server, Error: 40613)

Oury Ba-MSFT 19,581 Reputation points Microsoft Employee

2024-07-24T21:51:05.96+00:00
@Artsem Shumski Thank you for reaching out.

If a serverless database is paused, the first sign-in activity resumes the database and returns an error stating that the database is unavailable with error code 40613. Once the database is resumed, sign-in can be retried to establish connectivity. Database clients with a recommended connection retry logic should not need to be modified. For recommended patterns for connection retry logic, review:

Retry logic in SqlClient

Retry logic in SQL Database using Entity Framework Core

Retry logic in SQL Database using Entity Framework 6

Retry logic in SQL Database using ADO.NET

If you keep getting it after several retry then I would suggest opening a support ticket so we can help you get resolved it.

Regards,

Oury
Oury Ba-MSFT 19,581 Reputation points Microsoft Employee

2024-08-15T17:20:42.15+00:00

@Artsem Shumski

I am assuming is because the database is serverless and was paused. That would give a "not currently available" error while the database "wakes up".

I would recommend creating a support ticket so we can further investigate. If you have already created a support ticket, please do share the ticket number.

Regards,

Oury

Share via

Database 'DATABASENAME' on server 'server-name' is not currently available.

Your answer