Share via

Unable to connect to dedicated pool through Synapse Data Studio or SSMS

Ashu Anand 61 Reputation points
2023-08-03T16:44:55.55+00:00

We are unable to connect to Synapse dedicated pool through Synapse Data Studio as well as SSMS from last few days randomly. We are getting can't connect to synapse server. We have all the network firewall in place. The additional details explains that a network related or instance specific error occurred while establishing connection to server. (Provider: Named Pipes provider, error:40 - Could not open a connection to SQL server). The network path was not found.

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.


Answer accepted by question author

Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator
2023-08-11T20:18:56.0133333+00:00

The issue was resolved by whitelisting the IP address by adding the IP address to the access control list. This allowed connection to the dedicated SQL endpoint.

Was this answer helpful?

0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Javier Villegas 905 Reputation points MVP
    2023-08-09T17:06:56.98+00:00

    Have you tried with Azure Data Studio ? it should not be any difference but last week I had a similar issue and it worked for me

    Was this answer helpful?


  2. Vahid Ghafarpour 23,605 Reputation points
    2023-08-03T17:36:07.87+00:00

    Maybe changing DNS servers can help you.

    If the Named Pipes protocol is causing issues, you can use other connection protocols like TCP/IP.

    In SSMS, you can specify the protocol in the connection properties. For Synapse Data Studio, use the connection string with the specified protocol.

    Was this answer helpful?


Your answer

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