Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Connecting to Azure DB from SQL management studio is failing MSSQLSERVER_10060

I'm trying to connect to the sql server that has been created on Azure using SQL management studio, but i'm getting the following error.

enter image description here

Error message: An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)

I have enabled the client IP in the SQL server firewall settings.

Please let me know if anything else need to be taken cared. Thank you

like image 519
Aryan M Avatar asked Oct 08 '18 06:10

Aryan M


1 Answers

To resolve this error, try one of the following actions:

  • Make sure that you have configured the firewall on the computer to allow this instance of SQL Server to accept connections. That is, If you are trying to connect from within a corporate network, outbound traffic over port 1433 may not be allowed by your network's firewall. If so, you cannot connect to your Azure SQL Database server unless your IT department opens port 1433. On the Azure Side, you also need to check if the NSG (associated with that subnet the Azure SQL server sitting in) allows the client IP with the specific port 1433.
  • Add the client IP in the SQL server firewall settings if you enable a server-level firewall.
  • Telnet the current IP of your Azure SQL Database server with the port to verify the network connection.
like image 84
Nancy Xiong Avatar answered Sep 19 '22 11:09

Nancy Xiong