How to fix Azure SQL Database 08001 error - configure to allow remote connections.

Question

Hi,

I got a SQL Server on Azure SQL Database.

Whenever I try to access it via SSMS using my work laptop it works perfectly fine but whenever I try to access it via my remote desktop connection (which means I log in to the remote server and on that server, I try to access the Azure database). It doesn't let me connect to the Azure SQL Database and through the below error.

My remote server is Windows Server.

Error:

Cannot connect to xxxxxxxxxx.database.windows.net.

---

ADDITIONAL INFORMATION:

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.) (Microsoft SQL Server, Error: 10060)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-10060-database-engine-error

---

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

---

I tried playing with firewall settings but nothing helped. I don't know how to fix this issue. I am stucked here for the last two days.

Thanks,

Maaz

Answer 1

The error message you are receiving suggests that there is an issue with the network connection between your remote server and the Azure SQL Database. This could be due to a number of reasons, including firewall settings, network configuration, or DNS resolution issues.

Here are a few things you can try to troubleshoot the issue:

1. Check the network configuration on your remote server. Make sure that it has the correct IP address and subnet mask, and that it is connected to the correct network.
2. Check the firewall settings on your remote server. Make sure that the firewall is not blocking traffic to the Azure SQL Database.
3. Check the DNS resolution on your remote server. Make sure that it is resolving the correct IP address for the Azure SQL Database.
4. Check the connectivity between your remote server and the Azure SQL Database. You can try pinging the IP address of the database server from your remote server to see if it is reachable.
5. Check the configuration settings for your Azure SQL Database. Make sure that it is configured to allow remote connections and that the firewall rules are set up correctly.

Answer 2

Thanks for your question.

Kindly refer to the Microsoft document below for a list of all potential causes and solutions for such error.

Troubleshooting connectivity issues and other errors with Azure SQL Database and Azure SQL Managed Instance

https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql