Azure SQL Database connectivity issues

Users get the following connectivity error message while connecting to the Azure SQL Database from the SSMS client.

Connection to database master failed (error 10060, state 0): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to 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.)

Here, you need to check the Azure SQL server connection policy settings if you are selected the “Redirect” as connection policy make sure enable the ports 11000-11999 in the client machine side to connect the database successfully.

Azure SQL Database Connectivity Architecture – Azure SQL Database and Azure Synapse Analytics | Microsoft Docs

Solution:

1. You need to enable the ports 11000-11999 in the client machine firewall to use the redirect connection policy to avoid the connectivity error messages.
2. You can also use the proxy or default connection policy instead of redirect to connect the database successfully.
3. Redirect connection policy will improve the connectivity latency issues from the on premise client applications. So it is recommended to implement the “Redirect” connection policy.
4. If the client application is hosted in the Azure it will automatically use the “Redirect” connection policy.

Thank you!!

05/14/2021