Step by step SharePoint 2007 of 13: Implementing Form Certification (3)

To set the database connection string

Summary

This article will record the third part of the form authentication--Set the database connection string.

Because of the form authentication, the user information is stored in the database, which is the database we created in the first part, so we need to set up the database connection string for our website.

Body

The implementation process for each step is documented below.

1. First, follow the path shown in the diagram to find the folder that holds the settings file for the site that we created in this series of articles four.

2. Locate and open the Web.config file and add the <connectionStrings>......</connectionStrings> section to the location identified in the figure.

1 <connectionStrings>

2 <remove name= "LocalSqlServer"/>

3 <add name= "LocalSqlServer" connectionstring= "server= (local);D atabase=aspnetdb; Trusted_connection=true "providername=" System.Data.SqlClient "/>

4 </connectionStrings>