Share via

Connection Errors to the SQL server serverless pool

Rhuan Samary Barreto 95 Reputation points
2023-11-17T11:03:05.8066667+00:00

We are constantly observing errors on script pipeline activities running against the SQL Server Serverless Pool.

Failed to execute script. Exception: 'Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'tcp:syn-weu-dw-drilling-ondemand.sql.azuresynapse.net,1433', Database: 'analytics', User: ''. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.'

Today only way to solve this is to rerun the pipelines.

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.
Answer accepted by question author
  1. Smaran Thoomu 32,520 Reputation points Microsoft External Staff Moderator
    2023-11-21T11:36:40.8766667+00:00

    Hi Rhuan Samary Barreto,

    If rerunning the pipelines resolves the issue, it is possible that the issue is a temporary outage.

    To further investigate the issue, you can check the Azure Synapse Analytics status page to see if there are any known issues or outages affecting the service. You can also check the Azure portal for any alerts or notifications related to the SQL Server Serverless Pool.

    If the issue continues to occur, you can create a support ticket with Azure support to investigate the issue further. When creating the support ticket, be sure to include any relevant details, such as error messages, pipeline configurations, and steps to reproduce the issue. This will help the support team to investigate the issue more efficiently.

    In the meantime, you can try to implement some best practices for working with serverless SQL pool, such as optimizing storage layout, reducing the number of queries that execute simultaneously, and using client applications that are collocated with serverless SQL pool.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vinodh247 40,031 Reputation points MVP Volunteer Moderator
    2023-11-20T06:49:12.35+00:00

    Hi Rhuan Samary Barreto:

    Thanks for reaching out to Microsoft Q&A.

    Open the SQL database firewall: add client ip and Allow Azure services and resources to access this server in the portal.

    Pasting image from other blog for reference. Do try this and let me know.enter image description here

    Please 'Upvote'(Thumbs-up) and 'Accept' as answer if the reply was helpful. This will be benefitting other community members who face the same issue.

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.