Accessing Azure SQL database via Python via AD integrated authentication

Question

Hi All,

Is it possible to access Azure SQL DB via python through AD integrated authentication? As every where I am seeing either SQL Auth or SP Auth, no where is there any details w.r.t AD integrated Auth

Answer 1

Hi, @Priya Jha Thanks for the question and using the Microsoft Q&A platform
If I understand correctly you want to know if Azure SQL DB can be accessed via python through AD-integrated authentication.
Python connectivity uses pyodbc, which uses the ODBC driver.
AD Integrated auth is supported for Windows and only recent versions of Linux/macOS you can check this documentation here

This thread from the SO forum is also helpful for reference.

Hope this will help. Please let us know if any further queries.

Regards
Geetha

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer.