question

NeilPereira-2110 avatar image
0 Votes"
NeilPereira-2110 asked AmeliaGu-msft commented

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

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.

sql-server-generalazure-sql-databaseazure-synapse-analyticsazure-firewall
· 1
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.

@NeilPereira-2110

Please let us know if you need any further help regarding this.

Thanks
Navtej S

0 Votes 0 ·

1 Answer

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered AmeliaGu-msft commented

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.


· 1
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.

Hi Neil,

Did the answer above help you?

Please feel free to let us know if you have any other question.

If you find any post in the thread is helpful, you could kindly accept it as answer. This would benefit the community, and encourage the community member to keep working on your issues.

Best Regards,
Amelia

0 Votes 0 ·