Microsoft KB Archive/329828

= Windows user account name in the Enterprise resource pool reverts to the original Windows user account name in Project 2002 =

Article ID: 329828

Article Last Modified on 5/10/2007

-

APPLIES TO


 * Microsoft Project 2002 Professional Edition
 * Microsoft Project 2002 Standard Edition

-



This article was previously published under Q329828





SYMPTOMS
When you use the Enterprise resource pool to change a Windows user account name, the Windows user account name in the Enterprise resource pool may revert to the original Windows user account name that the resource had.



CAUSE
This issue may occur if the following conditions exist:
 * The Windows user account is a member of a Windows domain.
 * The Windows domain user account name is changed.
 * The Windows user account name is changed in Project Server.



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:  Start Enterprise Manager for SQL, and then click the Tables folder in the Project Server database. Right-click the MSP_Resources table, and then click Open Return All Rows. Click the record for the Window user account that has a Proj_ID of 1, and then press DELETE. Right-click the MSP_Web_Resources table, and then click Open Return All Rows. Click the Window user account, and then press DELETE. 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. Quit Project Web Access.</li> Start Project 2002 Professional, and then log with an account that has administrative credentials.</li> On the Tools menu, point to Enterprise Options, and then click Open Enterprise Resource Pool.</li> 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.</li> Save, and then close the Enterprise Resource Pool.</li> 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.</li> Click the resglobal project, and then click Check in.</li> In Project 2002, close, and then save the Enterprise resource pool.</li> 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.</li></ol>

Keywords: kberrmsg kbprb KB329828

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.