Find the setup file aspnet_regsql.exe located at either of the following locations depending upon your OS:
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