Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Newcomers » Newcomers » Unable to connect to Azure SQL database from Eclipse(Eclipse to Azure SQL Failing)
Unable to connect to Azure SQL database from Eclipse [message #1840390] Tue, 13 April 2021 21:47 Go to next message
Sathya Pothuru is currently offline Sathya PothuruFriend
Messages: 1
Registered: April 2021
Junior Member
I'm using Azure SQL instance for my project and from my old laptop i was able to connect to the Azure SQL server database from eclipse (with CISCO VPN connected to the Azure network). But recently I received a new laptop from office as the old one is corrupted. I installed SSMS and am able to connect to Azure SQL server. But I'm unable to connect to the same SQL server from eclipse IDE(2021-03).

I am getting the below exception

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host sql-XXXXXXX, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

If my machine is having any firewall issues, then even from SSMS I would not be able to connect. Not sure what is wrong? I've been trying to fix this for past 1 week but no luck.

Appreciate if someone can throw some light on this one
Re: Unable to connect to Azure SQL database from Eclipse [message #1840818 is a reply to message #1840390] Mon, 26 April 2021 06:52 Go to previous message
Emma Warner is currently offline Emma WarnerFriend
Messages: 2
Registered: February 2021
Junior Member
By default, Azure SQL Database instances are protected. They have a firewall in place that prevents any inbound connections. To use your database, you must instal a firewall rule that allows the database server to be accessed from a local IP address.

Since you set our local IP address at the start of this post, you can use the following command to open the server's firewall:

az sql server firewall-rule create \
--resource-group $AZ_RESOURCE_GROUP \
--name $AZ_DATABASE_NAME-database-allow-local-ip \
--server $AZ_DATABASE_NAME \
--start-ip-address $AZ_LOCAL_IP_ADDRESS \
--end-ip-address $AZ_LOCAL_IP_ADDRESS \
| jq
Previous Topic:federal MacOS Catalina: Wont start after upgrade, "An error has occurred."
Next Topic:Minify CSS and JS
Goto Forum:
  


Current Time: Sun Jul 25 01:12:09 GMT 2021

Powered by FUDForum. Page generated in 0.03300 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top