An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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:
- 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.
- 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.
- 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
ConnectionRetryCountandConnectRetryIntervaland a sufficient overallConnection Timeoutresolves this. - Ensure the connection timeout is greater than
ConnectRetryCount * ConnectRetryIntervalso 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.
- Serverless SQL pool deactivates after inactivity and needs to warm up on the first connection. Normally, a simple retry with proper
- Confirm connectivity from the client side
- From the client machine, verify that the workspace serverless endpoint
xxxxxxxxxxxxx-ondemand.sql.azuresynapse.netresolves 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
-ondemandserver name and a valid database name (for example,master).
- From the client machine, verify that the workspace serverless endpoint
- 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: