SYMPTOMS:

When you try to log on to Microsoft Office Project Server 2003 by using Microsoft Office Project Professional 2003 or by using Microsoft Project Web Access, you may receive the following error message: "Microsoft Project was unable to log you on at this time because the Microsoft Project Server database cannot be accessed. Please try again later or check with your Microsoft Project Server administrator. (5001)."

CAUSE: This issue may occur if one or more of the following conditions are true:

• The passwords for the MSProjectUser account and the MSProjectServerUser SQL Server account (or the accounts that perform those roles) do not match the accounts that Project Server 2003 has stored in the registry.


• The Security Identifier (SID) for the MSProjectUser account and the MSProjectServerUser account (or the accounts that perform those roles) may not match the SID in the Project Server 2003 database. The SIDs may not match if you restore a Project Server 2003 database from one SQL Server to another SQL Server.


• The program server that runs Microsoft Windows 2000 (any service pack) may not be able to successfully initiate a connection to the database server that runs Microsoft Windows Server 2003. Because Windows Server 2003 includes Microsoft Data Access Components (MDAC) 2.8, for the program server to successfully initiate a connection to the server, it may require matching MDAC components.

To obtain the latest version of MDAC and for other information about MDAC, visit the following Microsoft Developer Network (MSDN) Web site: http://msdn.microsoft.com/data/mdac/default.aspx. Note The version of the MDAC on the server is likely MDAC 2.7 Service Pack 1 (SP1) or earlier.

RESOLUTION

To resolve this issue, use one of the following methods depending on your situation.

Method 1: Change passwords on accounts

1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.

2. Locate the server, expand the server, and then click the Security\Logins subfolder.

3. Right-click the MSProjectServerUser account (or the equivalent account if you manually created the account), and then click Properties.

4. In the Password box, type a new password, click OK, retype the new password, and then click OK.

5. Repeat steps 3 and 4 for the MSProjectUser account (or the equivalent account if you manually created the account). Note: We recommend that you use different passwords for each account.

6. On the Console menu, click Exit.

7. Make changes to the Microsoft Project Server virtual directory, and then save the changes.

For additional information, click the following article number to view the article in the Microsoft Knowledge Base: 823529: How to use the Site Editor tool to create multiple Microsoft Project Web Access Web sites for Project Server 2003

8. Log on to the Project Server 2003-based computer by using Project Professional 2003 or by using Microsoft Project Server Web Access.

If you receive the same error message, go to Method 2.

Method 2: Replace the Project Server 2003 accounts

1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.

2. Locate and then expand the computer that is running SQL Server.

3. In the Security\Login folder, right-click the MSProjectUser account (or an equivalent account if you manually created the account), and then click Delete. When you are prompted to confirm the deletion, click Yes.

4. Repeat step 3 for the MSProjectServerUser account (or an equivalent account if you manually created the account).

5. In the Databases\ProjectServer\Users folder, right-click the MSProjectUser account, and then click Delete.

Repeat this step for the MSProjectServerUser account.

6. In Enterprise Manager, right-click the Security\Logon folder, and then click New Login.

7. Click the General tab. In the Name box, type the name of the MSProjectUser account.

8. Click SQL Server Authentication, and then type the value of the password for the MSProjectUser account.

9. In the Database box, point to the arrow, and then click ProjectServer.

10. Click the Database Access tab, click to select the ProjectServer check box, and then click to select the MSProjectRole check box.

11. Click OK, confirm the password, and then click OK.

12. Right-click the Security\Logon folder, and then click New Login.

13. Click the General tab. In the Name box, type the name of the MSProjectServerUser account.

14. Click SQL Server Authentication, and then type the value of the password for the MSProjectServerUser account.

15. In the Database box, point to the arrow, and then click ProjectServer.

16. Click the Database Access tab, click to select the ProjectServer check box, and then click to select the MSProjectServerRole check box.

17. Click OK, confirm the password, and then click OK.

18. On the Console menu, click Exit.

19. Log on to Project Server 2003 by using Project Professional 2003 or by using Microsoft Project Server Web Access.

Note The default files and directories for authentication are the following:

Main directory - Integrated Windows ONLY
LGNBSC.ASP - Basic
LGNINST.ASP - Windows
LGNINTAU.ASP - Windows
LGNINTPJ.ASP - Windows
LGNPS.ASP - Windows and Anonymous
LGNPSAU.ASP - Windows and Anonymous
LGNPSPJ.ASP - Windows and Anonymous