Hi, Does prisma support authenticating Azure SQL S...
# orm-help
m
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
Copy code
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>
n
Hey Manikanta 👋 Unfortunately, Prisma doesn’t support authentication of MS SQL Server through Azure Active Directory yet. Here’s a Feature Request for implementing the same. Can you please leave a 👍 to the issue so that our product and engineering team could prioritise it. From the issue, it seems there is this relevant npm package of ms-rest-nodeauth which might be helpful to you.