Microsoft KB Archive/283869

= PRJ2000: OLE DB Provider Error When You Browse to Microsoft Project Central =

Article ID: 283869

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Project 2000 Standard Edition

-



This article was previously published under Q283869



SYMPTOMS
When you attempt to browse to the Microsoft Project Central site for the first time, you receive the following error message:

Microsoft OLE DB Provider for SQL Server error '80040e37'

Invalid object name 'MSP_WEB_RESOURCES'.

/ProjectCentral/Library/PjQuery.asp, line 194



CAUSE
This error message may occur when the following conditions are true:
 * You use Microsoft SQL Server to store the Microsoft Project Central database.

-and-
 * You did not run the Microsoft Project Central scripts to create the Microsoft Project Central database before you installed Microsoft Project Central.



RESOLUTION
To resolve this issue, follow these steps.

NOTE: Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.

Step 1: Remove the ProjectCentral Virtual Folder from Microsoft Internet Services Manager
 Log on to the server computer as Administrator. Start Internet Services Manager. Expand *  (where  is the host name of the server computer). Locate and expand the Microsoft Project Central virtual server in the folder list. By default, this is Default Web Site. Right-click the ProjectCentral virtual directory, and then click Delete on the shortcut menu. Click Yes when you receive the following message:

Are you sure you want to delete this item?

 Quit Internet Information Services.</li></ol>

Step 2: Remove Microsoft Project Central
<ol> Click Start, point to Settings, and then click Control Panel.</li> In Control Panel, double-click the Add/Remove Programs icon.</li> In the Add/Remove Programs dialog box, click Microsoft Project Central Server  (where   is the service release of Project Central, such as SR-1), and then click Remove. Click Yes when you receive the following message:

Are you sure you want to remove Microsoft Project Central Server SR-1 from your computer?

Microsoft Windows removes Microsoft Project Central Server.</li> In the Add/Remove Programs dialog box, click Close.</li></ol>

Step 3: Run the Microsoft Project Central Server Database Creation Scripts
<ol> Start Microsoft SQL Query Analyzer.</li> In the Connect to SQL Server dialog box, click the server that you want in the SQL Server list.</li> Click to select the Start SQL Server if it is stopped check box.</li> Under Connect using, click SQL Server authentication (if it is not already selected).</li> In the Login name box, type SA (if it does not already appear).</li> In the Password box, type the password for the SA account, and then click OK. SQL Query Analyzer starts.</li> Make sure that Master is the selected database in the Query window.

NOTE: Master should appear in the status bar at the bottom of the Query window. When you position the mouse pointer over it, the following ToolTip appears:

Database Name: master

</li> Insert the Microsoft Project compact disc (CD) into the CD-ROM or DVD-ROM drive.</li> In the SQL Query Analyzer, click Open on the File menu.</li> In the Open Query File dialog box, navigate to the following location on the Microsoft Project Central CD:

PJCNTRL\ISAPI\1033

</li> Click Crttable.sql, and then click Open.

The query appears in the Query window.</li> On the Query menu, click Execute.

The Create Database process runs.</li> <li>In the Query window list that currently displays Master, click Project_CentralDb.</li> <li>On the File menu, click Open. In the Open Query File dialog box, click Insdefsq.sql, and then click Open.</li> <li>On the Query menu, click Execute.

NOTE: Wait for this process to finish before proceding to the next step.</li> <li>On the File menu, click Open. In the Open Query File dialog box, click Insdefsi.sql, and then click Open.</li> <li>On the Query menu, click Execute.</li> <li>When the process is finished, click Exit on the File menu.</li></ol>

Step 4: Reinstall Microsoft Project Central
<ol> <li>Start Windows Explorer and then browse to the location of the Microsoft Project 2000 CD.</li> <li>Double-click Setupsvr.exe and follow the instructions on the screen.</li> <li>On the Microsoft Project Central Server: Ready to Install page, click Customize.</li> <li>On the Microsoft Project Central Server: Choose Web Site page, click the Web site that you want in the list of Web sites (such as Default Web Site), and then click Next.</li> <li>On the Microsoft Project Central Server: Connect to Database page, click MSDE or SQL.</li> <li>In the Server box, type the name of the SQL database server. If you do not know the name of the SQL database server, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Click Start, point to Programs, point to Microsoft SQL Server, and then click Service Manager.</li> <li>In SQL Server Service Manager, note the name in the Server list.</li> <li>Quit SQL Server Service Manager.</li></ol> </li> <li>In the Logon ID box, type the SQL Server account name (such as SA ).</li> <li>In the Password box, type the password.</li> <li>In the Database box, type Project_CentralDb, and then click Test Connection.

Click OK when you receive the following message:

Test connection completed successfully.

Click Install Now to continue installing Microsoft Project

Central Server.

</li> <li>Click Install Now. After Microsoft Project Central Server is installed, click Yes when you are prompted to restart the computer.</li></ol>

Keywords: kberrmsg kbprb KB283869

-

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

© Microsoft Corporation. All rights reserved.