connect timed out error - Connecting to SQL Server from Databricks

patrickw
New Contributor II

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.".