Web Site Factory and other premium projects integrate ASP.NET Membership, a built-in way to store and validate user credentials. You can enable ASP.NET Membership by selecting the membership option in the code generator project wizard. This will enable numerous membership features including a fly-over sign-in window, self-service membership enrollment, membership bar, and membership manager.
The configuration of your project will be automatically changed to support the default membership provider available in ASP.NET. This provider defines a connection string that points to a local instance of Microsoft SQL Server Express. The provider will automatically connect to the server and dynamically create a database to maintain users, roles, and other membership features. The database will be created under ~/App_Data folder of your project.
This works great on a development machine with installed SQL Server Express. There are many situations when you want to use a standalone membership database or store ASP.NET membership data structures directly in your own database.
Project wizard offers an option that will enable a standalone membership database configuration. Here is the screen shot of the project wizard with the the standalone membership database enabled.
The connection string in the screen shot looks as follows:
Data Source=.;Initial Catalog=aspnetdb;Integrated Security=True;
We have configured the standalone membership database with the name aspnetdb.
You can read more about the configuration process at http://msdn.microsoft.com/en-us/library/ms229862(VS.80).aspx.
These are the steps that we have taken to create the aspnetdb database: