topic Remote SQL Server Instance Connection using JDBC in Data Engineering

Remote SQL Server Instance Connection using JDBC

Upendra_Dwivedi — Thu, 27 Mar 2025 13:37:36 GMT

Hi All,

I am connecting Remote SQL Server Instance using JDBC Driver, I have enabled TCP/IP and Setup the Firewall Rule. When i am querying the instance i am getting this error:

(com.microsoft.sqlserver.jdbc.SQLServerException) The TCP/IP connection to the host 192.168.x.x, 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."

Here is my code:

remote_table = (

spark.read

.format("sqlserver")

.option("host", "192.168.x.x")

.option("port", "1433")

.option("user", "xxxx")

.option("password", "xxxxxxxxx")

.option("database", "PRACTICE")

.option("dbtable", "dbo.TblGender")

.load()

)

remote_table.show()

My question is:
1. I am using ipv4 address of my personal computer as host, so is it correct?
2. If i am using the server name as host i am getting the same error.

If everything is correct then what could be the problem?

Thanks,

Upendra Dwivedi

Re: Remote SQL Server Instance Connection using JDBC

Davinder — Thu, 27 Mar 2025 18:21:18 GMT

192.168.x.x is a local ip address, it will not work in databricks notebook. First try to find your public ip address and try to connect through SQL Server management studio or .udl file. If it works, then you can use the same ip in notebook.

Re: Remote SQL Server Instance Connection using JDBC

turagittech — Fri, 28 Mar 2025 04:31:02 GMT

If you want to access a local SQL server, you'll need a Private Link to access the server. If it's on your own local machine, that's likely not possible. Creating a VPN to your machine is a unique problem, and you would be better off using a VM or a PAAS SQL database as the source.

Re: Remote SQL Server Instance Connection using JDBC

Upendra_Dwivedi — Fri, 28 Mar 2025 11:12:11 GMT

I am able to connect using is ip address through another laptop where ssms is installed and i have tested the connection using udl file, i am able to connect. i think this is not the problem.

Re: Remote SQL Server Instance Connection using JDBC

Upendra_Dwivedi — Fri, 28 Mar 2025 11:14:16 GMT

Thank You for the reply but the solution should be on-prem ssms or any other rdbms direct connection with azure databricks.

Re: Remote SQL Server Instance Connection using JDBC

Davinder — Fri, 28 Mar 2025 12:06:30 GMT

Yes, that will work because you are on the same local network. To connect from the outside network, you have to use the public ip address.