title: How to connect to Azure sql database with python SQL alchemy using Active directory integrated authentication
body: <p>I am trying to connect to an Azure SQL Database using SQL Alchemy in python. The database was recently moved to Azure from on-prem and as I understand that azure does not support Windows Auth.<br>
  I can connect to the DB from SSMS using Active Directory Integrated Auth.</p>
  
  <p>When the Db was on prem i would use the following connection string and it worked:</p>
  
  <pre><code>"mssql+pyodbc://@*Server*/*DB*?driver=SQL Server"
  </code></pre>
  
  <p>I have tried a few other connection string and cannot get it to work. </p>
  
  <pre><code>"mssql+pyodbc://@*Server*/*DB*?driver=SQL Server?Integrated Security=true"
  "mssql+pyodbc://@*Server*/*DB*?driver=SQL Server?Trusted_Connection=true"
  </code></pre>
  
  <p>i keep getting the following error, it seems like sql alchemy is trying to connect via windows auth by default is there anyway i can fix this ?</p>
  
  <pre><code>(pyodbc.Error) ('HY000', '[HY000] [Microsoft][ODBC SQL Server Driver][SQL Server]Windows logins are not supported in this version of SQL Server. (40607) (SQLDriverConnect); [HY000] [Microsoft][ODBC SQL Server Driver][SQL Server]Windows logins are not supported in this version of SQL Server. (40607)')
  (Background on this error at: http://sqlalche.me/e/dbapi)
  </code></pre>