How to create the asp.net membership database

To create the asp.net membership database, please follow the steps below.

1) create a sql server database and add a sql login

2) To run the command line version of aspnet_regsql.exe, you need to open a command prompt and go to the following directory:
%WINDOWS%\Microsoft.NET\Framework\v2.0.50727

3) Then run this command, which will create the proper database tables for the membership database.

-- To use SQL Server credentials (a UserID and Password), use:
aspnet_regsql.exe -S <server> -U <login id> -P <password> -d <database> -A all