question

MarkKasun-9119 avatar image
0 Votes"
MarkKasun-9119 asked PRADEEPCHEEKATLA-MSFT commented

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

I am trying to follow a simple tutorial on how to setup and use Azure Synapse Analytics but right out of the gate I can't run a query against a file in the Data Lake due to the error above. I opened up the fire wall rules and added my IP address and checked the box to allow all Azure resources but still looking at the error.

144658-azure-synapse-error.png


azure-synapse-analytics
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @MarkKasun-9119,

Welcome to the Microsoft Q&A platform.

Could you please check if the firewall on your network and local computer is allows outgoing communication on TCP ports 80, 443 and 1443 for Synapse Studio.

Please Verify that the workspace firewall is not blocking the user connection.

 Telnet synapsename-ondemand.sql.azuresynapse.net  1443

For more details, refer to Azure Synapse Analytics IP firewall rules.

0 Votes 0 ·

Hello @MarkKasun-9119,

Follow up to see if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.

0 Votes 0 ·

Still having the issue. I opened the ports: 80, 443 & 1443 and restarted my laptop and it worked for a while. This morning I got the same error again even after re-starting my machine so I am not off to a good start.

0 Votes 0 ·
Show more comments

I am attaching what I see this morning.

146168-azure-synapse-error1.png


0 Votes 0 ·

Hello @MarkKasun-9119,

Could you please recheck if the firewall on your network and local computer is allows outgoing communication on TCP ports 80, 443 and 1443 for Synapse Studio.

Please Verify that the workspace firewall is not blocking the user connection: Telnet synapsename-ondemand.sql.azuresynapse.net 1443

0 Votes 0 ·

0 Answers