Azure synapse studio connectivity using Private end point

Question

I am trying to setup a secure connection to Azure synapse studio using private link hub and private endpoint as mentioned in the below doc,

https://docs.microsoft.com/en-us/azure/synapse-analytics/security/how-to-connect-to-workspace-from-restricted-network

However, it throws an error.

"Unable to connect to serverless SQL pool because of a network/firewall issue"

Please note- We use a VPN to connect to on-premise company network from home and access the dedicated pool using a SQL authentication. This works absolutely fine.

The private endpoint and link hub are mounted on the same subnet as the one we use for dedicated pool. So I don't think there is any problem with allowing certain ports for serverless pool. Please correct me.

What am I missing here?

Answer 1

Unable to connect to serverless SQL pool because of a network/firewall issue ?

Synapse Studio

Follow this instruction for troubleshooting network and firewall:

1. When creating your workspace, managed virtual network should be enabled and make sure to allow all IP addresses.

Note: If you do not enable it, your synapse studio will not be able to create a private endpoint. So if you fail to do this during synapse workspace creation. You will not be able to change this later and you will be a force to recreate the synapse workspace.

2. Create a Managed private endpoint, connect to your data source and check whether the managed private endpoint is approved or not.

To know more details please Refer this link:

https://www.thedataguy.blog/azure-synapse-understanding-private-endpoints/

https://www.c-sharpcorner.com/article/how-to-setup-azure-synapse-analytics-with-private-endpoint/

How to set up access control for your Azure Synapse workspace - Azure Synapse Analytics | Microsoft Docs