To create the asp.net membership database, please follow the steps below.
-
Find the setup file aspnet_regsql.exe located at either of the following locations depending upon your OS:
%windir%\Microsoft.NET\Framework\v2.0.5027
%windir%\Microsoft.NET\Framework64\v2.0.5027 -
When the ASP.NET SQL Server Setup Wizard appears, select “Configure SQL Server for application services”, then click Next
-
Enter the SQL Server and Database name.
-
Click Next and Finish
To run the command line version of aspnet_regsql.exe, you need to open a command prompt and 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