This is the complete error-
TITLE: Connect to Server
Cannot connect to adityapatil-server.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
OK
I tried putting my IP address in the allowed IP address list in the firewall settings in Azure portal but it is still not working. Could someone help me how to resolve this problem. Also my main aim is to connect the Azure SQL database to a python environment. Will this error affect my connection with python as well?
Also, any alternative method is surely appreciated.
Aditya Patil is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
3
Check if Azure SQL database have configured with VPN setting.
Will this error affect my connection with python as well?
It depends based on how the Azure SQL access is configured, if you have configured it to access within the same resources or VPN or same subscription and if your code is deployed in the Azure based on the above configuration it can connect to the database.
But it will affect your local development, see if you have enabled public access