Default ASPNet sql db

I keep wasting time re-searching for this every time that I need it. I'm posting it here so I'll never lose it again!

The default aspnet sql database provides you with generic user and role functionality, among a lot of other things.

To set it up:

• start up visual studio 200X command prompt. It's usually located in start menu/all programs/visual studio 200X/visual studio tools/visual studio 200X command prompt
• Type in aspnet_regsql.exe and hit enter
• It launches the app that sets up the default aspnet sql database
• Enter your server name, login info, and database name (usually found in your connection string)
• aspnet_regsql.exe can create or modify an existing database.
• It creates a bunch of tables and stored procedures necessary for the user and role functionality.