You can translate the question and the replies:

Unable to connect to Azure SQL because of TCP/IP

Hi, I have been unable to connect to my Azure SQL database that i'm running on Azure VM. I am using Denodo Express to tryout the product. It keeps returning the "Unable to establish connection: The TCP/IP connection to the host, port 1433 has failed", but I just don't understand where the problem is. In Azure portal i've enabled access to the Azure database from external services and in the allowed ip addresses my ip address is there. So where could the problem be? This is the picture of the error in Denodo https://imgur.com/a/MqPGGNh
user
08-05-2020 10:35:38 -0400

1 Answer

Hi, I see that you have mentioned an invalid hostname “host” in the database URI and even the error message suggests the TCP/IP connection to host “host” failed. I would use a valid hostname to test the connectivity and below are some general [troubleshooting guidelines for the TCP/IP error](https://javarevisited.blogspot.com/2015/10/sql-server-jdbc-error-tcpip-connection-to-host-failed-port-1433.html), when you connect with Azure SQL Server. * Make sure SQL server is running on the port 1433. * Check if the SQL server is up and running on the instances. * Check TCP/IP configurations are enabled. * Check if the firewall is opened for access to the port from the instances where the VDP server is running. To make sure that ports are opened. Try the telnet command from VDP server. telnet <Hostname> 1433 Hope this helps!
Denodo Team
11-05-2020 02:28:23 -0400
You must sign in to add an answer. If you do not have an account, you can register here