Use Azure ID Token for sql connection string in .Net Core?

Question

I've managed to stumble my way through using a redirecting login page that gets an ID token via Azure AD registered app. The token is then sent to my backend apis in .Net Core 3.1. I'm told the database is restricted to only those of a certain AD group.

Currently my connection string has Trusted_Connection=True.

I'm not really sure where to go or how to search my issue. Any guidance, as I've never really done something like this, would be appreciated.

Answer 1

@Davis, Daniel Thank you for reaching out.

Your web app needs to authenticate and access the Azure SQL Database via a managed Identity.
A detailed tutorial is here to guide you with the process.

Please follow the steps and get back to us if you still face any issues.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.