Configuring Multiple ASP.NET MVC Sites To Use a Single Database For Authentication/Membership

Question

Is it possible for two or more ASP.NET MVC sites to use a single SQL Server database for authentication and other things?

Here's how I'm thinking of setting it up: I will combine the current database of each site into one single database, prefixing the tables with the name of the site they belong to. I currently have authentication tables generated by the asp.net_regsql.exe utility. How should I combine those tables? I'm guessing that the way to do it is to somehow set the "application_id" column in those tables...

Thanks in advance.

SztupY · Accepted Answer · 2010-04-24 23:04:09Z

1

The membership/role/profile/session providers usually have an option to include an "ApplicationName" This applicationname will be used to filter out the membership/role/profile/session queries. You can set this applicationname in the web.config like this:

<providers>
  <clear/>
  <add name="ProviderName"
     (...)
     applicationName="/"
     (...)
     >
</providers>

Change this tag (by deafult is't "/", but you can change it to any string you want) in each application and the M/R/S/P provider will take care of the rest

answered Apr 24, 2010 at 23:04

SztupY

10.6k9 gold badges68 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Maxim Zaslavsky Over a year ago

So this means that my hypothetical design of combining the databases will work? Thanks!

Collectives™ on Stack Overflow

Configuring Multiple ASP.NET MVC Sites To Use a Single Database For Authentication/Membership

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related