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
- Install MSDE or SQL Server 2005 in your PC, if it is not already installed.
- 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.
- Open Visual Studio and open the Servers window.
- 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
- Connection string is available by right click on database and click Properties.
- 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
- Enter the COR Web home page. (this automatically configures the database, and adds a user named 'Bob' with password 'Bob'.