Unable to connect to Azure SQL DW & DB via SSMS, SSDT - error 10060

Question

Hi,
I'm trying to connect to Azure SQL Data Warehouse via SSMS and SSDT from my local with SQL Authentication and AD universal MFA, but I'm unable to and getting error number 10060 (Connected host failed to respond ).

I've added my client IP to server firewall settings on Azure Portal,
I've also opened port 1433 on my local firewall settings.

I was initially able to connect for few hours, and then after a gap of 10-12 hours, when tried again, been getting the same error since 2 days.

Not sure what I'm still missing and why the error still persists.

Please guide.

Best,
Neil.

Answer 1

Hi Neil,

Could you please Telnet the current IP of your Azure SQL DW server with the port 1433 to verify the network connection?

Please try to configure NSG to allow the client IP with the port 80, 443 ,1433 and port range 11000-11999.

For more details, please refer to the following articles which might help:

Error 10060: Configure Azure NSG for Azure DB and Azure DW Connectivity
Connecting to Azure DB from SQL management studio is failing MSSQLSERVER_10060

Best Regards,
Amelia

Please remember to click " Accept Answer" and upvote the responses that resolved your issue. This can be beneficial to other community members reading this thread.