You receive the "Error Number: 0x80040e4d" error message and you cannot publish new projects after you move the ProjectServer database to a new server or to a new instance of SQL Server in Microsoft Project Server 2002 and in Project Server 2003 (840464)


The information in this article applies to:

  • Microsoft Office Project Server 2003
  • Microsoft Project Server 2002

SYMPTOMS

In Microsoft Project Server 2002 and in Microsoft Office Project Server 2003, you may find that after you move the Microsoft Project Server database to a new server or to a new instance of Microsoft SQL Server, you cannot publish new project plans or build On-Line Analytical Processing (OLAP) cubes. Error messages that have descriptions that are similar to the following are logged in the event log.Project Server 2002
File: Drive:\Proj10\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80040e4d
Description: Assert Detected. The error code was also included. ___________________________________

Description: Access denied while opening project '<PC10DSN>\resglobal'
File: Drive:\Proj10\WebClient\source\utility\pjadorsutil2.cpp Line: 1691
Error Number: 0x80040e4d
Description: Assert Detected. The error code was also included.
___________________________________

Description: Access denied while opening project '<PC10DSN>\ProjectName.published'
Project Server 2003
File: Drive:\Office\Dev\Project\WebClient\Source\Utility\Pjadorsutil2.cpp
Line: 1691
Error Number: 0x80040e4d
Description: Assert Detected. The error code was also included.

CAUSE

This issue occurs if both of the following conditions are true:
  • You moved the Microsoft Project Server database to a new server or to a new instance of SQL Server.
  • The connection settings for the existing data source name (DSN) on the server are not updated to use the new location of the database.

RESOLUTION

To resolve this issue, create a new DSN that is named PC10DSN and that uses the new location of the SQL Server database. To do this, follow these steps:
  1. Delete the existing DSN that is named PC10DSN. To do this, follow these steps:
    1. Click Start, point to Administrative Tools, and then click Data Sources (ODBC).
    2. Click the System DSN tab.
    3. In the System Data Sources table, click PC10DSN, and then click Remove.
    4. When you are prompted to confirm the removal, click Yes.
  2. Create a new DSN that is named PC10DSN. To do this, follow these steps:
    1. Click Add.
    2. In the Create New Data Source dialog box, click SQL Server, and then click Finish. The Create a New Data Source to SQL Server Wizard starts.
    3. In the Name box, type PC10DSN, type the description that you want in the Description box, and then click the server that you want to connect to in the Server box.
    4. Click Next, and then follow the instructions on the remaining pages of the wizard to create the DSN.
    5. Click OK.

MORE INFORMATION

For more information about Project Server 2002, visit the following Microsoft Web site:

http://www.microsoft.com/office/previous/project/default.asp

Modification Type:MinorLast Reviewed:1/11/2006
Keywords:kberrmsg kbprb KB840464 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.