Windows user account name in the Enterprise resource pool reverts to the original Windows user account name in Project 2002 (329828)

RESOLUTION

To resolve this issue, use either of the following methods.

Method 1

Create a new Project Server account, and then use this account for the resource.

Method 2

Delete the records for the affected Windows user account in the MSP_RESOURCES and the MSP_WEB_RESOURCES table. You must then re-create the Windows user account in Project Server, open the Enterprise resource pool, and then create the Windows user account for the resource:

1. Start Enterprise Manager for SQL, and then click the Tables folder in the Project Server database.
2. Right-click the MSP_Resources table, and then click Open Return All Rows.
3. Click the record for the Window user account that has a Proj_ID of 1, and then press DELETE.
4. Right-click the MSP_Web_Resources table, and then click Open Return All Rows. Click the Window user account, and then press DELETE.
5. Log on to Project Web Access (PWA) with the Project Administrator account, click Admin, click Manage Users and Groups, and then create the Windows user account.
6. Quit Project Web Access.
7. Start Project 2002 Professional, and then log with an account that has administrative credentials.
8. On the Tools menu, point to Enterprise Options, and then click Open Enterprise Resource Pool.
9. Click Add\Remove, and then re-create the resource name by using the Windows User account. The name of the resource must be the same name as the account in Project Server.
10. Save, and then close the Enterprise Resource Pool.
11. You may receive the following error message:
    the Enterprise Resource Pool is checked out
    If this occurs, log on to PWA by using the Project Administrator account, click Admin, click Manage Enterprise Features, and then click Check in enterprise projects.
12. Click the resglobal project, and then click Check in.
13. In Project 2002, close, and then save the Enterprise resource pool.
14. You may receive the following error message:
    [Microsoft][ODBC SQL Server Driver][SQL Server] Cannot insert duplicate key row object 'MSP_RES_GLOBAL_BINARY' with 'I_MSP_RES_GLOBA'.
    If this occurs, click OK. The Enterprise resource pool is saved with the new Windows user account.