Going from AAD to on premise AD for sql database connection?

Davis, Daniel 1

My organization has AAD and a local AD. The two sync password wise. I've created an app that uses an Azure App registration so that they can use their email/password to get in. However, for my .net core backend, I'm not sure how to switch this over. The SQL database that is on premise uses the local AD for security.

I've sort of stumbled my way to this point and I'll do my best to understand any solutions, but will likely have follow up questions. I'm more of a front end developer. Currently I have an ID token I'm using to get pass authorization I've set up for the endpoints on a controller level. We use an ACL for the app registration as well. I'm also not sure how to set up the connection string to handle a token.

I also wasn't sure what to put as a tag..

Marilee Turscak-MSFT 33,801 Reputation points Microsoft Employee

2021-05-25T20:08:41.713+00:00

Are you trying to get rid of the Azure AD and just have the local one, or are you trying to just make the authentication happen with the local credentials? If all of the users exist on-premises then you should be able to add them as administrators. As I'm sure you know there isn't a way to write back users from AAD to AD so all of the users will need to exist on-premises.