Configuring the SQLMembershipProvider
The SqlMembershipProvider is the default Membership provider. Unless otherwise configured, it stores membership information in the local ASPNETDB.mdf Microsoft SQL Server Express database located in your application’s App_Data folder. This database is created for you automatically the first time that you use Membership.
If you want to store membership information in some other Microsoft SQL Server database, you need to perform the following two tasks:
• Add the necessary database objects to the Microsoft SQL Server database.
• Configure your application to use the new database.
To complete the first task, you can use the aspnet_regiis command-line tool. This tool is located in the following folder:
\Windows\Microsoft.NET\Framework\v4.0.30319 ...