Create a ASP.NET Membership Security Database

Prerequisites:

Visual Studio 2005 installed

SQL Server 2005 installed (with a current database and your windows account with dbo/admin rights)

1. Locate your SQL Database – make sure you have rights to it
2. Locate the Visual Studio Command Prompt (All Programs -> Microsoft Visual Studio 2005 -> Visual Studio Tools -> Visual Studio 2005 Command Prompt)
3. Run the following command: aspnet_regsql -S (local) -E -d MyDatabaseName -A all

Note:  Change (local) to your SQL database server name if it is not local. Change MyDatabaseName to your database name (suggest you create a test database first to test this on – don’t do directly on production database!)
DONE!  Now have a look at your database. You should see a whole lot of new tables and stored procedures etc within your database.
For more help on the switches on the command above, type: aspnet_regsql /? within the Visual Studio 2005 Command Prompt.