Create a ASP.NET Membership Security Database
- Locate your SQL Database – make sure you have rights to it
- Locate the Visual Studio Command Prompt (All Programs > Microsoft Visual Studio 2005 > Visual Studio Tools > Visual Studio 2005 Command Prompt)
- 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.
Any questions about the above process then feel free to post a comment and I will reply.
Yellow Duck Guy