Built-in Serverless pool unavailable

Question

I am trying to use the Built-in Serverless pool in Azure Synapse Analytics. However in Manage > SQL Pools, it has status Unavailable. why would this be?

Answer 1

The solution for me was to add my client IP to the allowed access points in the firewall rules for the synapse workspace.
This can be found in the Security > Networking section of the Synapse workspace settings.

https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-ip-firewall

Answer 2

Hi @Harold Anderson ,

Thanks for using Microsoft Q&A forum and posting your query.

From the past instance I have noticed that sometime this issue is transient and it auto resolved if you clear your cache and restart your browser.

But if that is not the case, 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.
Also, you need to allow outgoing communication on UDP port 53 for Synapse Studio. To connect using tools such as SSMS and Power BI, you must allow outgoing communication on TCP port 1433.

For more info please refer to this doc: https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-ip-firewall#connect-to-synapse-from-your-own-network

Hope this info helps. Do let us know how it goes.

----------

• Please don't forget to click on and 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