Web site project login against separate database

I use the Visual Studio 2010 - and I'd like to create a ASP.NET Website - however I would like to check the login against a separate database and not the .mdf file because I need a bit more flexibili开发者_开发问答ty and the access to the remaining items in my database.

Does anyone of you have a good solution how I could achieve that?

Edit: The database which I have is a SQL Server 2008 R2 database, if that matters.

I'm guessing that you are using a web application in ASP.net 4.0 (which I believe is the default for VS2010).

In the web.config file, under connection strings, by default there is a connection named "ApplicationServices", this connection string can be changed to another database.

To setup a database with the tables needed for ASP.net Membership, you will need to use a tool called Aspnet_regsql.exe. More information on aspnet_regsql.exe

But, it sounds as though you may need more experience in general with ASP.net around connections string and memberships and profiles etc. with a little more knowledge of connection strings etc, it would be clearer to you. The tutorials on the ASP.net site are always a good place to start.

Learning a little more about asp.net, you may find that you change you mind and instead of requiring a separate database, you may discover that things like "database deployments" etc may help.