ON-Prem SQL Server Direct Connection with Azure Databricks

Upendra_Dwivedi
Databricks Partner

Hi All,

I have SSMS installed and have some data there which i want to export to Databricks and process it there. Databricks is hosted on Azure Cloud and I am wondering if it is possible. I have tested it using JDBC connection but i am getting error: 

The TCP/IP connection to the host LAPTOP-XXXXXX, port 1433 has failed. Error: "LAPTOP-XXXXXX. 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.


I have enabled TCP/IP and also added rule in Windows Firewall to allow access but still not able to connect and getting same error. 

Please let me know if i need to set anything up before establishing connection.

Thankyou in advance.