When you attempt to install or log on to Microsoft Project Central, you receive the following error message:

This problem may be due to any of the following causes.

Cause 1

Anonymous access for the ProjectCentral virtual directory or PJDBComm.dll has been disabled.

Cause 2

Microsoft SQL Server is set to allow Windows Authentication only.

Cause 3

The Microsoft Project Central database (Project_Centraldb) is damaged.

Resolution for Cause 1

1. Click Start, point to Settings, and then click Control Panel.
2. Double-click Internet Services Manager.
3. Expand the server name by clicking the plus sign (+).
4. Expand Default Web Site.
5. Right-click the ProjectCentral virtual directory, and then click Properties.
6. Click the Directory Security tab.
7. Next to Anonymous Access and Authentication Control, click Edit.
8. Click to select the Anonymous Access check box, and then click Edit.
9. Verify that the User Name setting is IUSR_computer_name or a valid domain user name.
10. Verify that the Allow IIS to control password check box is selected for the IUSR account, or type and confirm the domain user's password.
11. Click OK until the Internet Information Service console is active.
12. Expand the ProjectCentral virtual directory.
13. Click the ISAPI folder.
14. In the right pane, right-click PJDBCOMM.dll, and then click Properties.
15. Click the Directory Security tab.
16. Next to Anonymous Access and Authentication Control, click Edit.
17. Verify that the Anonymous Access check box is selected, and that the User Name and password settings match the settings from steps 9 and 10.
18. Click OK until the Internet Information Service console is active.
19. Close the Internet Information Services console.

Resolution for Cause 2

Change the authentication setting from Windows Only to SQL Server and Windows. To do this, follow these steps:

1. Start SQL Enterprise Manager.
2. Right-click the server name, and then click Properties.
3. On the Security tab, click SQL Server and Windows.
4. Click OK.
   
   SQL Server prompts you to restart the service automatically.

Resolution for Cause 3

Remove Microsoft Project Central and run the SQL Scripts to re-create the database.

NOTE: When you run the SQL scripts again, the Microsoft Project Central database is reset, and any work that was already done in Microsoft Project Central is deleted.

Before you follow the steps below, refer to the Microsoft Project 2000 Resource Kit Toolbox for a .bat file that you can use to back up your Microsoft Project Central database.

You can find the Microsoft Project 2000 Resource Kit Toolbox at the following Microsoft Web site:

To Remove Microsoft Project Central

1. Select Start, point to Settings, and then click Control Panel.
2. Double-click the Add-Remove Programs icon.
3. Select Project Central in the list of programs, and follow the instructions on the screen to remove it.

To Create the Database and Tables for Microsoft SQL Server or MSDE

1. Click Start, and then click Run.
2. In the Open box, type cmd, and then click OK.
3. At the command prompt, change directories to the CD-ROM drive, and on the Microsoft Project CD, change directory to Pjcntrl\Isapi\1033 (or the appropriate folder for your language). To do this, type the drive letter of your CD-ROM drive, press ENTER, and then type the following commands:
   cd pjcntrl
   cd isapi
   cd 1033
4. To run the script that creates the Microsoft Project Central Project_CentralDB database and tables, type the following command:
   osql -U account_name -P password -i Crttable.sql
   For example, if the account name is sa and the password is ProjectPW, the command line is:
   osql -U sa -P ProjectPW -i Crttable.sql
   NOTE: The parameter letters U, P, d, and i are case-sensitive.
5. Press ENTER.
6. Type the following command to create the default records in the tables:
   osql -U account_name -P password -d db_name -i Insdefsq.sql
   For example:
   osql -U sa -P ProjectPW -d Project_CentralDB -i Insdefsq.sql
7. Press ENTER.
8. To create the default values in the records, type the following command:
   osql -U account_name -P password -d db_name -i Insdefsi.sql
   For example:
   osql -U sa -P ProjectPW -d Project_CentralDB -i Insdefsi.sql
9. Press ENTER.

You are now ready to install Microsoft Project Central Server, as described in the Srvsetup.htm file, which is located in the PRJCNTRL\Help\1033 folder on the Microsoft Project 2000 CD.