Connect to an on-prem SQL server database

[thushar]

Need to connect to an on-prem SQL database to extract data, we are using the Apache Spark SQL connector. The problem is can't able to connect to connection failure

SQLServerException: The TCP/IP connection to the host ***.***.X.XX, 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.".

Enabled TCP/IP and updated the port as well, still getting the same error. Any solution here?

Do we need to create a virtual network for on-prem - Azure databricks communication ?

Without a virtual network is this possible?

[Mohit_m · Accepted solution]

Maybe you can check the below docs and see if something is missing in the set up

https://docs.microsoft.com/en-us/azure/databricks/administration-guide/cloud-configurations/azure/on...

[jose_gonzalez]

Thank you for sharing this docs. Marking this response as "best"

[Kaniz]

Hi @Rob S (Customer)​ , We haven't heard from you on the last response from @Mohit Miglani​ ​, and I was checking back to see if his suggestions helped you. Or else, If you have any solution, please share it with the community as it can be helpful to others.

Also, please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.