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.
(An alternate approach if you are comfortable installing databases is found at Install included database.)
Microsoft includes a Forms Authentication Database creation tool (often referred to as Personalization) in .NET 2.0 Framework. There are a number of classes included in .NET that make it easy to use.
Many projects use this database as a base to provide login capabilities and personalization for Web Parts. Jetfire Web Parts is one of these projects.

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 is "aspnet-demo".

Configure the database for Jetfire

  1. Enter the Jetfire Web Demo home page. (this automatically configures the database, adds subscriptions and a user named 'Bob'.

Last edited Jul 4, 2008 at 8:52 PM by CharlesW, version 6

Comments

No comments yet.