connect timed out error - Connecting to SQL Server from Databricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-26-2024 12:23 PM
I am getting a connect timed out error when attempting to access a sql server. I can successfully ping the server from Databricks. I have used the jdbc connection and the sqlserver included driver and both result in the same error. I have also attempted to use the IP address instead of the host name in the connection strings but still get an error. I worked with my system admin and they were able to see the traffic on the firewall when the server was pinged but did not see any traffic when I ran the jdbc and sqlserver code cells. Is there any driver I would need to install on my cluster to be able to connect to this sql server?
Error message:
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host ********, 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.".