Microsoft KB Archive/840464

= You receive the &quot;Error Number: 0x80040e4d&quot; 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 =

Article ID: 840464

Article Last Modified on 11/30/2007

-

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: :\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 '\resglobal'

File: :\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 '\ .published'

Project Server 2003
File: :\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:  Delete the existing DSN that is named PC10DSN. To do this, follow these steps:  Click Start, point to Administrative Tools, and then click Data Sources (ODBC). Click the System DSN tab. In the System Data Sources table, click PC10DSN, and then click Remove. When you are prompted to confirm the removal, click Yes.</li></ol> </li> Create a new DSN that is named PC10DSN. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> Click Add.</li> 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.</li> 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.</li> Click Next, and then follow the instructions on the remaining pages of the wizard to create the DSN.</li> Click OK.</li></ol> </li></ol>

<div class="moreinformation_section">

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

http://support.microsoft.com/ph/2692

Keywords: kberrmsg kbprb KB840464

-

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

© Microsoft Corporation. All rights reserved.