"The Windows user account or user name for the affected user account conflicts with an existing account on the server (0x8C04000D)" error message when you try to publish a project in Microsoft Project (321350)

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: Click OK when you receive this error message. The Enterprise resource pool is saved with the new Windows user account.