Hi, Does prisma support authenticating Azure SQL Server through Azure Active directory? For more info
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?tabs=azure-powershell
In sequelize, we can pass options: {dialect, authentication: {type: 'azure-active-directory-password'}} Which uses
npm mssql as connection library
Is it even feasible in Prisma?
Our team uses Azure SQL Server using Active Directory users. I tried to connect DB using below URL
DATABASE_URL=sqlserver://<HOST>:<PORT>;database=<DB_NAME>;user={<USERNAME>@<AD_DOMAIN>};password={PASSWORD};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.<http://database.windows.net;loginTimeout=30;authentication=ActiveDirectoryPassword|database.windows.net;loginTimeout=30;authentication=ActiveDirectoryPassword>