"Serverless SQL pool has encountered an internal error."

Question

I've created a Synapse workspace and now getting this error for the Built-in SQL pool. Any ideas what can be the reason?

Answer 1

Hello @Andrei ,

Welcome to the Microsoft Q&A platform.

You may try the below options to troubleshoot most frequent problems with serverless SQL pool in Azure Synapse Analytics.

Option1: Add the client IP to firewall riles and see you can access the serverless pool .

IP firewall rules grant or deny access to your Synapse workspace based on the originating IP address of each request. You can configure IP firewall rules for your workspace. IP firewall rules configured at the workspace level apply to all public endpoints of the workspace (dedicated SQL pools, serverless SQL pool, and development).

For more details, refer to Azure Synapse Analytics IP firewall rules

Option2: Grant access to the SQL pools.

Access to SQL pools for other users and for the workspace MSI is controlled using SQL permissions. Assigning SQL permissions requires that SQL scripts are run on each SQL database after creation.

For more details, refer to Grant access to SQL pools

Option3: You need to make sure that you have open ports to synapse endpoints.

Make sure that the firewall on your network and local computer allows outgoing communication on TCP ports 80, 443 and 1443 for Synapse Studio.

For more details, refer to Connect to Synapse from your own network

Option4: It’s an intermittent issue. I would suggest you re-try again and check if that works.

In case if it doesn’t solve. You please try the below:

• Clear “Cookies and Cached data” of your browser.
• Private Mode (New InPrivate Window).
• Try in different browser.

For more details, refer to this article contains information about how to troubleshoot most frequent problems with serverless SQL pool in Azure Synapse Analytics.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators