Share via

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KalyanChanumolu-MSFT 8,321 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