Cannot connect to Azure Synapse serverless db - Currently Unabailable

WZIAFP 247 Reputation points
2026-04-14T09:37:38.48+00:00

One of our business critical database is reporting the following error when connecting for over 2 hours:

TITLE: Error


Database 'xxxxxxx' on server 'xxxxxxxxxxxxx-ondemand.sql.azuresynapse.net' is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the session

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=40613&LinkId=20476

Azure Synapse Analytics
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.


1 answer

Sort by: Oldest
  1. AI answer

    2026-04-14T09:37:56.37+00:00

    Error 40613 indicates that the database on the Synapse serverless endpoint is currently unavailable and that the issue is expected to be transient.

    For a serverless SQL pool in Azure Synapse, take these steps:

    1. Treat it as a transient connectivity issue
      • Error 40613 is documented as a transient fault: the database is not currently available and the client should retry the connection.
      • Implement retry logic in the client (with backoff) instead of failing immediately. If the duration of failures exceeds about a minute or you see repeated occurrences during the day, it is considered abnormal and should be escalated.
    2. Check service and workspace health
      • Check the Azure status page for any regional issues affecting Azure SQL or Synapse.
      • In the Azure portal, open the Synapse workspace and check Resource Health and Activity Log for the serverless SQL pool to see if there are ongoing platform incidents or maintenance.
    3. Verify that the issue is not just warm-up
      • Serverless SQL pool deactivates after inactivity and needs to warm up on the first connection. Normally, a simple retry with proper ConnectionRetryCount and ConnectRetryInterval and a sufficient overall Connection Timeout resolves this.
      • Ensure the connection timeout is greater than ConnectRetryCount * ConnectRetryInterval so that all retries can complete.
      • If the error has persisted for more than a few minutes (as in this case, over 2 hours), it is no longer just a warm-up delay and should be treated as a platform issue.
    4. Confirm connectivity from the client side
      • From the client machine, verify that the workspace serverless endpoint xxxxxxxxxxxxx-ondemand.sql.azuresynapse.net resolves and is reachable (DNS and network).
      • Ensure that outbound access to *.database.windows.net / Synapse endpoints and port 1443 is not blocked by local or corporate firewalls or network security devices.
      • If using a tool that is not Synapse-aware, connect using the same options used for SQL Server/Azure SQL Database, specifying the -ondemand server name and a valid database name (for example, master).
    5. If the problem persists beyond transient expectations
      • Because this is a business-critical database and the error has already persisted for hours, open an Azure support ticket from the Azure portal.
      • Include:
        • The exact error message and code (40613).
        • The session tracing ID from the error ({E5028EA1-97B1-4CAE-AAAC-7B807975DEC0}).
        • The connection ID and timestamps.
        • Region and workspace name.
      • Azure support can correlate the session tracing ID with backend logs to identify whether there is a platform-side issue with the serverless SQL pool or the specific database.

    If any client applications are not yet using retry logic, update them to handle transient faults (40197, 40613, and similar) by retrying with exponential backoff, as recommended for cloud databases.


    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

    1 person found this answer helpful.

Your answer

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