Creating a Forms Authentication database

This page is an installation guide for creating a Forms Authentication database. It takes less than 20 minutes to add the database.
Microsoft includes a Forms Authentication Database creation tool (often referred to as Personalization) in .NET 2.0 Framework.
Many projects use this database as a base to provide login capabilities and personalization for Web Parts. COR Web Parts is one of these projects. COR makes Personalization easy to use.

Creating the Forms Authentication Database

1. Install MSDE or SQL Server 2005 in your PC, if it is not already installed.
2. Go to 'C:\Windows\Microsoft.NET\Framework\v2.0.50727' and double-click aspnet_regsql.exe. (It takes a few minutes for the database to be created.
3. Open Visual Studio and open the Servers window.
4. Add the new Database to the Servers (right click and Add Connection...)
   • The Server name is the name of the database server that you are using (it can be on a separate machine)
   • Logon characteristics are determined by how you installed the Database Server
   • Connect to a database - you should be able to select a database name.
   • Test the Connection
5. Connection string is available by right click on database and click Properties.
6. Enter this string as the Connection string in the web.config file.

NOTE: The database default name used in the web.config file is "aspnet".

Configure the database for Jetfire

1. Enter the COR Web home page. (this automatically configures the database, and adds a user named 'Bob' with password 'Bob'.