To create the asp.net membership database, please follow the steps below.
 
  1. 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
  2. When the ASP.NET SQL Server Setup Wizard appears, select “Configure SQL Server for application services”, then click Next
  3. Enter the SQL Server and Database name.
     
  4. 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
Tags: , , | Categories: Database | Tips and tricks | Web development