Authenticate Basic MVC site via SQL DB using username and password on SharePoint Online

Question

Hi

I have a client with the following scenario.

They have the following solution in SharePoint On-Prem and we need to get a solution so that we can move it to SharePoint Online.

They have a basic MVC site that contains a simple login screen. Users who login are authenticated via a SQL Database using a username and password.

What we need to happen is this: after successfully being authenticated, the user is redirected to a temp SharePoint Online site. The site is very basic, no fancy stuff.

They are trying to implement some sort of pass-through authentication with SharePoint Online.

Any recommendations on what approach we should look at would be appreciated.

Thanks

Answer 1

You need to implement Azure AD SSO into your MVC application. This means storing the users in Azure AD (which is the only identity storage SharePoint Online uses with no option to change it) and using the MSAL library with your MVC application. You will then no longer use the SQL database for account storage.