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"