Connecting SQL Server From Databricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-17-2025 04:33 AM
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-17-2025 04:39 AM
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-17-2025 04:40 AM
@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
