Forms authentication in Project Server 2007

Create the MembershipProvider database on your SQL Server

1.       Open a Command Prompt window.

2.       From any directory, enter: <Windows Directory>\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe -A m -E

3.       This creates a database named aspnetdb, authenticating with your existing Windows.

Extending the web application

1. Open the SharePoint Central Administration Web site by clicking Start, pointing to Administrative Tools, and then clicking SharePoint 3.0 Central Administration.

2. On the Application Management tab, select Create or extend Web application.

3. In the next page, select Extend an existing Web Application.

4. If a Select Web Application dialog box appears, select the Web site you want to extend (for example, Default Web Site), and then click OK.

5. Select Create a new IIS web site.

6. Change the port number to 80 (or to another unused port). Verify that the Description and Path numbers change correctly.

7. Note the URL located in the Load Balanced URL box. This is the URL for the new forms-authenticated site. You can use the default URL provided in the box or enter a different URL.

8. Click OK.

Configure site for SQL Membership Provider

1. From the Application Management page, click Authentication providers.

2. For Intranet Zone, click the Windows link.

3. For Authentication Type, select Forms.

4. In the Membership provider name box, enter:

AspNetSqlMembershipProvider

5. Click Save.

Updating the Web.config file to add the SQL Membership Provider

1. Open the Internet Information Services Manager on the front-end Web server. You can do this by clicking Start, choosing the Run command, typing Inetmgr in the Open box, and then clicking OK.

2. In IIS Manager, expand the computer name and then click the Web Sites folder.

3. Under the Web Sites folder, you will see the Web site you had created previously. Right-click this site and choose Explore.

4. Right-click web.config, choose Open, and then open the file using an editing tool such as Notepad.

5. Add the following entry to Web.config (the best place to add it is immediately after the </ConfigSections> section):

<connectionStrings>

<remove name="LocalSqlServer" />

<add name="LocalSqlServer" connectionString="data source=sampledatabase;Integrated Security=SSPI;Initial Catalog=aspnetdb" />

</connectionStrings>

<add name="LocalSqlServer" connectionString="data source=Computer1\Project;Integrated Security=SSPI;Initial Catalog=aspnetdb" />

6.            Make sure the connection string points to the SQL Membership Provider database in which you will be storing user accounts (for example, Intial Catalog=aspnetdb).

Creating users using Forms Authentication

1. In a Command Prompt window, navigate to the directory containing PJFormsAuthUpgrade.exe. (The default location is Program Files\Microsoft Office Servers\12.0\Bin.) Type the following text at the command prompt and customize it for your environment:

PjFormsAuthUpgrade.exe -createusersfile -log forms.log -passwordlength 8 –url http://sample:81/pwa -usersfile users.xml

2.            Open the Users.xml file in Notepad. The file should be similar to the following:

<?xml version="1.0"?>

<Users xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/Project/Users.xsd">

<UpdateUser>

<DisplayName>sales</DisplayName>

<EmailAddr>sales@sampleproject.com</EmailAddr>

<LogonName>sales</LogonName>

<Password>?rBt8Rv(</Password>

<Guid>c4572c86-7452-4d29-9d28-1a8a49ad5f89</Guid>

<PasswordQuestion>Please add a password question?</PasswordQuestion>

<PasswordAnswer> Please add a password question?</PasswordAnswer>

</UpdateUser>

<UpdateUser>

<DisplayName>finance</DisplayName>

<EmailAddr>finance@sampleproject.com</EmailAddr>

<LogonName>finance</LogonName>

<Password>!rHtNv)</Password>

<Guid>d2372c86-7452-4d29-8d67-1a8a49ad5f34</Guid>

<PasswordQuestion>Please add a password question?</PasswordQuestion>

<PasswordAnswer> Please add a password question?</PasswordAnswer>

</UpdateUser>

</Users>

3. Add data to the <PasswordQuestion> and <PasswordAnswer> elements. These elements may be required by the SQL Membership Provider database in order for users to reset their password if they have forgotten it.

4. Save the file.

Now just add users in the project web access.