Setup ASP.NET Membership and Roles

Using Windows authentication you would type the following command to have Windows automatically setup the tables for ASP.NET Membership:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe -E -S server\instanceName -A mr -d database

Using SQL authentication type:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe -U user -P password -S server\instanceName -A mr -d database