Prisma

Hi folks, we have Managed Azure SQL DB and we are trying to connect to it using Prisma Client in a NodeJS app.
We followed the docs to create DATABASE_URL but it keeps throwing:
`Error: Error in connector: Authentication failed for user 'myuser'`
Our connection string is created like:
`DATABSE_URL="<sqlserver://HOST>:PORT;database=DB_NAME;username=DB_USER;password=DB_PASSWORD;integratedSecurity=true;trustServerCertificate=true"`

Has anyone tried connecting to Azure SQL server using Azure Active Directory Password authentication in Prisma?

<@UQT5WQX9S> would you be able to help? :smiley:

It seems to be failing only because the username/password is an Azure Active Directory username/password.
Is there a flag to make it explicit and make it work?

Hey Kapil :wave::skin-tone-4:
Prisma currently doesn’t support Azure AD authentication yet.
There’s a <https://github.com/prisma/prisma/issues/7673|GitHub issue> open requesting for the integration. Feel free to :plus-one-+1: the issue.