Hi, Is there any way to make Prisma work with MSSQ...
# orm-help
a
Hi, Is there any way to make Prisma work with MSSQL/SQL Server with the Azure AD Token flow instead of the username/password flow? We won't be able to use Prisma with our application unless we can use this authorization scheme. I looked through the code, and it seems this is not yet possible, but should be possible with a minor adjustment to the Prisma APIS (which would be a semver major change). https://github.com/prisma/prisma/issues/12562 I made said issue before realizing there was a Slack workspace
n
Hey Andrew đŸ‘‹ Thank you for creating the GitHub Issue, we already do have an existing GitHub Issue and related Feature Request to support these kinds of scenarios. This is not implemented yet but you could probably try implementing this workaround
a
Thanks. The issue I see is that the workaround would require a way to pass through the AAD token -- since the AAD token can't be part of the connection string URL.
n
That’s true, I would recommend you describe your use case as a comment in the issue, also you could watch the issue so that you can receive an email when there are updates on that issue.
a
Thanks!