Connecting to SQL Azure from a Java application

1
votes

I have a Java Application that connects to an SQL server database via JDBC driver and everything works fine. I have lately migrated my Database to the Azure SQL server and so the Java application. Of course, I modifided the connction string to point at this new adress, but I keep getting this next error:

Connection TCP/IP of the HTTP xxxxxxx.database.windows.net, port 1433: ERROR : connection time out. verify connexion properties, make sure an instance of SQL server is running and accepts TCP/IP connections and verify that Firewall is not blocking TCP connexion.

here is my connection sring:

jdbc:sqlserver://xxxxxxxxx.database.windows.net:1433;databaseName=xxxxxxx;user=xxxxxxx@xxxxxxxxx;password=xxxxxxx;encrypt=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30;

What is missing right there ?

1
sql-serverazurejdbcconnection-stringazure-sql-database

1 Answers

1
votes

Have you allowed access to the database server from that particular IP address?

If not, go to the management portal

  • select the database
  • on the bottom right, select the server
  • go to the configure tab
  • enter the ip address (or range of them)