What causes SYNAPSE_SQL_0009?

Private endpoint connection was created but not yet approved by the workspace owner. DNS resolution is returning the public IP instead of the private endpoint IP. Network Security Group (NSG) is blocking traffic to the private endpoint subnet. The client is on a different VNet that is not peered with the private endpoint VNet

How do I fix SYNAPSE_SQL_0009?

Step 1: Verify the private endpoint connection is in 'Approved' state in the Synapse workspace.. Step 2: Check DNS resolution: `nslookup .sql.azuresynapse.net` should resolve to a private IP.. Step 3: Review NSG rules on the private endpoint subnet — port 1433 must be allowed.. Step 4: If connecting from another VNet, set up VNet peering or use Azure Private DNS zones.

High severityconnectivity

Power BI Refresh Error:
SYNAPSE_SQL_0009

What does this error mean?

The connection to Synapse via a private endpoint failed — the endpoint is not configured correctly or is not approved.

Common causes

1Private endpoint connection was created but not yet approved by the workspace owner
2DNS resolution is returning the public IP instead of the private endpoint IP
3Network Security Group (NSG) is blocking traffic to the private endpoint subnet
4The client is on a different VNet that is not peered with the private endpoint VNet

How to fix it

1Step 1: Verify the private endpoint connection is in 'Approved' state in the Synapse workspace.
2Step 2: Check DNS resolution: `nslookup <workspace>.sql.azuresynapse.net` should resolve to a private IP.
3Step 3: Review NSG rules on the private endpoint subnet — port 1433 must be allowed.
4Step 4: If connecting from another VNet, set up VNet peering or use Azure Private DNS zones.

Frequently asked questions

How do I monitor for Private Endpoint Connection Failed in my pipelines?

Connect Azure Data Factory to MetricSign — failed pipeline runs trigger incident alerts with the root cause, so your team is notified before users notice report failures.

Official documentation: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/troubleshoot-synapse-studio