- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-05-2022 03:03 AM
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?
- Labels:
-
Apache Spark SQL
-
Server
-
SQL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-05-2022 03:11 AM
Maybe you can check the below docs and see if something is missing in the set up
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2022 05:14 PM
Thank you for sharing this docs. Marking this response as "best"
