PRJ2000: OLE DB Provider Error When You Browse to Microsoft Project Central (283869)

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

1. Log on to the server computer as Administrator.
2. Start Internet Services Manager.
3. Expand *computer name (where computer name is the host name of the server computer).
4. Locate and expand the Microsoft Project Central virtual server in the folder list. By default, this is Default Web Site.
5. 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?

6. Quit Internet Information Services.

Step 2: Remove Microsoft Project Central

1. Click Start, point to Settings, and then click Control Panel.
2. In Control Panel, double-click the Add/Remove Programs icon.
3. In the Add/Remove Programs dialog box, click Microsoft Project Central Server service release (where service release 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.
4. In the Add/Remove Programs dialog box, click Close.

Step 3: Run the Microsoft Project Central Server Database Creation Scripts

1. Start Microsoft SQL Query Analyzer.
2. In the Connect to SQL Server dialog box, click the server that you want in the SQL Server list.
3. Click to select the Start SQL Server if it is stopped check box.
4. Under Connect using, click SQL Server authentication (if it is not already selected).
5. In the Login name box, type SA (if it does not already appear).
6. In the Password box, type the password for the SA account, and then click OK. SQL Query Analyzer starts.
7. 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

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

    PJCNTRL\ISAPI\1033

11. Click Crttable.sql, and then click Open.
    
    The query appears in the Query window.
12. On the Query menu, click Execute.
    
    The Create Database process runs.
13. In the Query window list that currently displays Master, click Project_CentralDb.
14. On the File menu, click Open. In the Open Query File dialog box, click Insdefsq.sql, and then click Open.
15. On the Query menu, click Execute.
    
    NOTE: Wait for this process to finish before proceding to the next step.
16. On the File menu, click Open. In the Open Query File dialog box, click Insdefsi.sql, and then click Open.
17. On the Query menu, click Execute.
18. When the process is finished, click Exit on the File menu.

Step 4: Reinstall Microsoft Project Central

1. Start Windows Explorer and then browse to the location of the Microsoft Project 2000 CD.
2. Double-click Setupsvr.exe and follow the instructions on the screen.
3. On the Microsoft Project Central Server: Ready to Install page, click Customize.
4. 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.
5. On the Microsoft Project Central Server: Connect to Database page, click MSDE or SQL.
6. 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:
   1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Service Manager.
   2. In SQL Server Service Manager, note the name in the Server list.
   3. Quit SQL Server Service Manager.
7. In the Logon ID box, type the SQL Server account name (such as SA).
8. In the Password box, type the password.
9. 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.

10. Click Install Now. After Microsoft Project Central Server is installed, click Yes when you are prompted to restart the computer.