Share via

Built-in serverless SQL pool Unavailable

Jānis Bojārs 20 Reputation points
2023-07-23T04:29:12.8033333+00:00

I made Synapse environment, bet Built-in serverless SQL pool is Unavailable.

Networking setup - allowAll

I am not sure, that this is necessary, but made myself as Owner in Access Control

User's image

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.
5,373 questions
0 comments
Accepted answer
  1. Vinodh247 34,661 Reputation points MVP Volunteer Moderator
    2023-07-23T04:47:56.14+00:00

    Hi Jānis Bojārs,

    Thanks for reaching out to Microsoft Q&A.

    As per microsoft, common issues for this might be improper network configuration.

    Incorrect network configuration is often the cause of this behavior. Make sure the ports are properly configured. If you use a firewall or private endpoints, check these settings too. Finally, make sure the appropriate roles are granted and have not been revoked.

    Can you confirm if you have added your IP address to the allowed access points in the firewall rules?

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

    Please Upvote and Accept as answer if the reply was helpful, this will be benefitting the other community members who go through the same issue.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.