topic Re: Connecting SQL Server From Databricks in Data Engineering

Connecting SQL Server From Databricks

GowthamR — Wed, 17 Sep 2025 11:33:54 GMT

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,

Re: Connecting SQL Server From Databricks

BS_THE_ANALYST — Wed, 17 Sep 2025 11:39:04 GMT

@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

Re: Connecting SQL Server From Databricks

BS_THE_ANALYST — Wed, 17 Sep 2025 11:40:55 GMT

@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