So you need to create a new aspnetdb database

Posted by jeff.story

August 11, 2008

If you do any development with ASP.NET you will run into the aspnetdb database. This database is an essential component to the membership and webparts framework.

If you are a developer like myself, I find that I add a number of test users (and data) to the database and don’t want the data being moved to the production application. You really have 2 options, delete the data out and hope you get it all, or start with a fresh db and add the needed accounts.

I won’t go through the first option because I usually just opt for the second. It is a much cleaner approach in my mind. To create a new database you can use one of the following commands executed at a command prompt from the “C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\” directory:

Launch the wizard and go through the steps.
aspnet_regsql.exe

Create a database on a remote server using your current credentials.
aspnet_regsql.exe -S <server> -E

Or you can get crazy and create a database on the local server, only to be used for profiles, and authenticate with the current logged on user.
aspnet_regsql.exe -A p -E

To get all the options and switches aspnet_regsql.exe -?

Hopefully this information will help you when you are deploying your next application.