question

DavisDaniel-8667 avatar image
0 Votes"
DavisDaniel-8667 asked KalyanChanumolu-MSFT answered

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

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.

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KalyanChanumolu-MSFT avatar image
0 Votes"
KalyanChanumolu-MSFT answered

@DavisDaniel-8667 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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.