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
