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

Davis, Daniel 1 Reputation point
2021-05-20T18:35:43.953+00:00

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
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KalyanChanumolu-MSFT 8,316 Reputation points
    2021-05-21T12:00:42.717+00:00

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

    0 comments No comments