topic Re: Connect to an on-prem SQL server database in Data Engineering

Connect to an on-prem SQL server database

thushar — Tue, 05 Jul 2022 10:03:44 GMT

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?

Re: Connect to an on-prem SQL server database

Mohit_m — Tue, 05 Jul 2022 10:11:39 GMT

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-prem-network

Re: Connect to an on-prem SQL server database

jose_gonzalez — Fri, 02 Sep 2022 00:14:26 GMT

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