Connecting SQL Server From Databricks

[GowthamR]

Hi Team,

Good Day!

Iam trying to connect to sql server from databricks using pyodbc , However iam not able to connect , And I have tried many ways like adding the init script in the cluster configuration etc,But it is showing me error,I want to know each steps clearly so that it will be easy for me to connect to sql server.Thanks in advance!

Thanks,

[BS_THE_ANALYST]

@GowthamR  did you go through the documentation supplied by Databricks yet for connecting to SQL Server: https://learn.microsoft.com/en-us/azure/databricks/ingestion/lakeflow-connect/sql-server-pipeline 

Just to check, is this SQL Server on your local machine or is it remote i.e. like dev/prod or somewhere on prem. I ask because if it's on your local machine, you'll likely be encountering issues there. Your home internet won't be designed (nor should it be) to open up the firewall. 

All the best,
BS 

[BS_THE_ANALYST]

@GowthamR supplying errors, if possible, given that they aren't leaking credentials (please mask those in the screenshots) will be really useful for helping us to debug what's happening. 

All the best,
BS