DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 321350 - Last Review: September 18, 2011 - Revision: 6.0

This article was previously published under Q321350

On This Page

Method 3 Start Microsoft Project, and then open your project file. On the Tools menu, point to Enterprise Options, and then click Open Enterprise Resource Pool. Click Open/Add. In the Resources task pane, click Specify people and equipment for the project. In the Specify Resources task pane, click the option that you want, and then enter the resource information for each resource that you want to add. In the Windows User Account column, type the appropriate Windows user account name for each resource that you add by using the following format: DomainName\UserName. When you are finished, click Done in the Specify Resources task pane. Change to:

SYMPTOMS

When you try to publish a project in Microsoft Project, a flashing red exclamation mark may appear next to the Microsoft Project Server Spooler icon in the notification area. If you double-click the Microsoft Project Server Spooler icon, you receive the following error message in the Microsoft Project Server Spooler dialog box:
The Windows user account or user name for the affected user account conflicts with an existing account on the server (0x8C04000D).

CAUSE

This behavior may occur if you try to publish project information to Microsoft Project Server and either of the following conditions is true:
  • There is a conflict with an existing entry in the MSP_WEB_RESOURCES database table in Microsoft Project Server.

    -or-
  • The resource names of the persons assigned to tasks in the project that you want to publish are not correctly matched to the appropriate Windows user accounts.

    Note The Windows User Account field of a resource identifies Windows users to Microsoft Project Server.

RESOLUTION

To resolve this behavior, follow these steps in the order in which they are presented.

Step 1: Look for Duplicate Entries in the Microsoft Project Server Database Table

  1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
  2. Expand Microsoft SQL Servers, expand SQL Server Group, and then expand ServerName, where ServerName is the name of the server.
  3. Expand Databases, and then expand ProjectServer.
  4. Click Tables.
  5. In the right pane, right-click MSP_WEB_RESOURCES, point to Open Table on the shortcut menu, and then click Return all rows.

    Verify that duplicate entries do not exist for the resource name.

Step 2: Match the Windows User Account to the Resource Name

When you assign a resource (in this case a person) to a task, make sure that the resource name is matched to the appropriate Windows user account. To do this, use one of the following methods.

Method 1

  1. Start Microsoft Project, and then open your project file.
  2. On the View menu, click Resource Sheet.
  3. On the Project Guide toolbar, click Resources, and then click Specify people and equipment for the project in the Resources task pane.
  4. Click Enter resources manually in the Specify Resources task pane.
  5. In the Windows User Account column, type the appropriate Windows user account name for the resource by using the following format: DomainName\UserName.
  6. When you are finished, click Done in the Specify Resources task pane.

Method 2

  1. Start Microsoft Project, and then open your project file.
  2. On the View menu, click Gantt Chart.
  3. In the Task Name column, click the task to which you want to assign a resource.
  4. On the Tools menu, click Assign Resources.
  5. Double-click the resource that you want to assign to the task.

    The Resource Information dialog box appears.
  6. In the Resource Information dialog box, do one of the following:
    • Click Windows Account to use the resource name to locate the Windows user account in the address book.

      -or-
    • In the Windows User Account box, type the appropriate Windows user account name for the resource by using the following format: DomainName\UserName.
  7. Click OK, and then click Close.

Method 3

Delete the records for the affected Windows user account in the MSP_RESOURCES, for PROJ_ID =1 only. This is the entry for the Enterprise Resoruce Pool and the MSP_WEB_RESOURCES table. After you do this, re-create the Windows user account in Microsoft Project Server, and then open the Enterprise resource pool and create the Windows user account for the resource. To do this, follow these steps:
  1. Start Enterprise Manager for SQL, and then click the Table folder in the ProjectServer database.
  2. Right-click the MSP_Resources table, and then click Open Return All Rows. Select the record for the Window user account that has a Proj_ID of 1, and then delete it.
  3. Right-click the MSP_Web_Resources table, and then click Open Return All Rows. Select the record that is the Window user account, and then delete it.
  4. Log on to Microsoft Project Server as the Administrator, and then create the Windows user account in Admin\Manager Users and Groups for the user.
  5. Quit Microsoft Project Web Access.
  6. Start Microsoft Project 2002 Professional, and then log on as a user who has Administrative rights.
  7. On the Tools menu, point to Enterprise Options, and then click Open Enterprise Resource Pool.
  8. Click Add\Remove.
  9. Re-create the resource name by using the Windows User account. The name of the resource must be the same name as the name of the account in Microsoft Project Server.
  10. Quit and save the Enterprise Resource Pool.
  11. You may receive a message that states that the Enterprise Resource Pool is checked out. If you receive this message, log on to Microsoft Project Server as the Administrator, and then click Admin\Manage Enterprise Features\Check in enterprise projects.
  12. Click the resglobal project, and then click Check in.
  13. Go back to Microsoft Project 2002, and then quit and save the Enterprise resource pool.
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'.
Click OK when you receive this error message. The Enterprise resource pool is saved with the new Windows user account.

MORE INFORMATION

For more information about how to assign resources to tasks in Microsoft Project, click Microsoft Project Help on the Help menu, type assign a resource in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

APPLIES TO
  • Microsoft Project 2002 Professional Edition
  • Microsoft Project Server 2002
Keywords: 
kbtshoot kbprb KB321350
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support