How to implement Forms-based authentication for Office SharePoint Server 2007 by using SQL Server

INTRODUCTION

MORE INFORMATION
To implement Forms-based authentication for Office SharePoint Server 2007 by using an instance of SQL Server that is installed on the same computer, follow these steps:

1- Create an Aspnetdb database to use for storing membership and role information. To do this, follow these steps:
a) At a command prompt, change to the .NET Framework directory. Typically, the .NET Framework directory is located at C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727.

Create a database on the local SQL server. To do this, type the following command, and then press ENTER: Aspnet_regsql -A all –E
Note To create a database on a different server computer, use the following command to determine the appropriate switch to use:
aspnet_regsql /?

b) -If you are creating the SQL Server provider database for the first time, you must also create one or more users and, optionally, one or more roles. The users and roles are the security principals that you add to the Policy for the extranet Web programs and the SharePoint Site Groups. There are multiple ways to create security principals. Typically, a complete install of Microsoft Visual Studio 2005 is used together with the ASP.NET 2.0 Administration tool to create users and the roles. If you experience issues with Visual Studio 2005, contact Microsoft Customer Support Services.

2- Create a Windows SharePoint Web application and enable Windows authentication for the main Web site for internal users to access the site.

3- Create another SharePoint Web application, extend the Web application, and then map the new Web application to the main Web site.
You must enable the Forms authentication type for the extended Web application. To enable Forms-based authentication, you must configure the Membership providers and the Role managers in the Web.config file for the SharePoint central administration site and the Web.config file for the extended Web application. To do this, follow these steps:

a)-Open the Web.config file for the SharePoint central administration site by using Notepad
Note:
Note Typically the Web.config file is located under C:\Inetpub\Wwwroot\Wss\VirtualDirectories
b)-Paste the following lines of code at the end of the Web.config file under the tag.
Note In the following command, replace the Database Server Name placeholder with the database server name and replace the Database Name placeholder with the name of the database.

<connectionStrings>

<add name="aspnetdbConnectionString" connectionString="Data Source=<Database 

Server Name>;Initial Catalog=<Database Name>;Integrated Security=True" 

providerName="System.Data.SqlClient" />

</connectionStrings>