Forum Discussion
Solved
Sql database in Fabric
Hi everyone, I’m trying to connect an ODBC data source to a SQL Database in Microsoft Fabric, but I’m facing this error: Microsoft ODBC Driver for SQL Server Version 18.04.0001 Running conne...
Thank you for the response.
I followed all the suggested steps:
- Confirmed DNS and network connectivity (nslookup, Test-NetConnection).
- Verified I have ODBC Driver 18 and pyodbc installed.
- Ran my Python script with ActiveDirectoryInteractive and also tried other auth methods.
- Checked my Azure tenant and found I have no valid subscription assigned or active.
It turns out my subscription status is causing the issue. I don’t have any active Azure subscription in my tenant.
Hi OliverO - You have to be logged in for integrated auth to work. Running az login will get you a logged in session. If you open a new command window, run az login then run your python script in the same window I'd expect it to just work. That is actually how I do testing against our various test tenants.
Should I open a support case?
Yes, creating a support case will be fastest/safest.
thanks - submitted