Synapse Workspace Provisioning Failure After Network Configuration Change

Mondli Ndlela 0 Reputation points
2025-08-05T10:23:34.2+00:00

I was conducting end-to-end testing after deploying/spinning-up a Logic App in our dev environment. Our objective was to test the workflow's ability to trigger Synapse pipelines via web requests.

Since our environment security policies typically prohibit public access to resources and workspaces,

we temporarily changed the Synapse workspace from private to public access to complete our testing and workflow configuration.

The plan was to revert to private access through private endpoints once testing was finalized.

CURRENT ISSUE: Following the network access change, we are experiencing resource provisioning failures that have rendered the Synapse workspace inaccessible.

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.
{count} votes

1 answer

Sort by: Most helpful
  1. Pratyush Vashistha 975 Reputation points Microsoft External Staff Moderator
    2025-08-06T06:06:55.15+00:00

    Hello Mondli Ndlela!

    Thanks for posting your query on QnA! Let me try to help you with my observations here.

    See, when a Synapse workspace is configured for private access, its internal services and components (like Spark pools and SQL serverless endpoint) communicate exclusively within your VNet via private endpoints. When you switch to public access and then back to private, this process can lead to a state where the Synapse control plane cannot correctly provision or manage its internal resources. This can cause a generic "Resource provisioning failed" error that indicates a problem with the service's ability to communicate with its dependencies over the network.

    Suggested Actions to Resolve

    Since this is a provisioning failure, direct troubleshooting of a running resource isn't possible. You can try the following steps to troubleshoot it better

    Revert to Public Access (Temporarily): The fastest way to restore functionality and make the workspace accessible for management is to temporarily toggle the network access back to public. This often resolves the provisioning issue by allowing the internal services to bypass the private endpoint configuration and recover.

    1. Delete and Recreate Private Endpoints: Once the workspace is accessible again, delete the existing private endpoints and their corresponding DNS records. Then, recreate the private endpoints for your Synapse workspace. This ensures a clean, correct link between the workspace and your VNet. For detailed instructions, refer to the Azure Synapse Analytics Private Endpoints documentation and https://learn.microsoft.com/en-us/azure/synapse-analytics/security/connectivity-settings?tabs=workspace.
    2. Validate DNS Resolution: A common cause of issues with private endpoints is incorrect DNS resolution. The private DNS zone (e.g., privatelink.sql.azuresynapse.net) must be linked to your VNet and contain A records that point to the private IP addresses of your Synapse resources. You can refer this similar issue as well for troubleshooting.

    Also, To better understand your specific situation and provide more targeted advice, could you please answer the following:

    1. After changing the Synapse workspace's network access back to private, did you delete and recreate the private endpoints?
    2. Can you confirm that the private DNS zones for the Synapse workspace are properly configured and linked to the VNet? Specifically, check for the privatelink.sql.azuresynapse.net and privatelink.dev.azuresynapse.net zones and their A records.
    3. What specific actions were you performing when the provisioning failed? Were you trying to start a Spark pool, run a pipeline, or something else?

    Please try to share some screenshot of the error or logs if possible so that I can guide you more accurately.

    Thanks, and Happy to Help!

    Pratyush

    0 comments No comments

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.