Built-in Serverless pool unavailable

Harold Anderson 101 Reputation points
2021-11-19T05:28:48.873+00:00

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?

150911-image.png

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.
4,108 questions
0 comments No comments
{count} votes

Accepted answer
  1. Harold Anderson 101 Reputation points
    2021-11-20T05:24:01.417+00:00

    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


1 additional answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,402 Reputation points Microsoft Employee
    2021-11-19T16:32:53.26+00:00

    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 130616-image.png and upvote 130671-image.png 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