PRJ2000: No Names Appear in Dropdown Lists in Microsoft Project Central (276455)


The information in this article applies to:

  • Microsoft Project 2000
This article was previously published under Q276455

SYMPTOMS

When you log on to Project Central in Project 2000, you do not see a user name in the drop down list of the Logon.asp page or columns are missing on pages such as Portfolio View.

CAUSE

This problem occurs because the three scripts to create the Project Central Database did not run correctly or were run in the wrong order.

WORKAROUND

To work around this problem, re-run the following scripts: Crttable.sql, Insdefsq.sql, Insdefsi.sql, by using the following steps.

Re-run the Three Scripts

To re-run the three scripts for Microsoft Desktop Engine (MSDE) and Microsoft SQL 7.0 through an MS-DOS command prompt, follow these steps:
  1. Insert your Project 2000 CD.
  2. Copy the following folder from your CD to the root of drive C, PJCNTRL\ISAPI\1033.
  3. Open a DOS Command Prompt and change the folder to your 1033 folder, for example, cd 1033.
  4. Re-run the three scripts in the following order:

    osql -U <account name> -P <password> -I Crttable.sql
    osql -U <account name> -P <password> -d <Database Name> -i Insdefsq.sql
    osql -U <account name> -P <password> -d <Database Name> -i Insdefsq.sql

    For example, if the Database Base Account name is sa, the password is ProjectPW, the commands would be:

    osql -U sa -P ProjectPW -i Crttable.sql
    osql -U sa -P ProjectPW -d Project_CentralDB -i Insdefsq.sql
    osql -U sa -P ProjectPW -d Project_CentralDB -i Insdefsi.sql

Re-run the Scripts from SQL Query

If you are using SQL Server 7.0 or later, you can re-run the scripts from SQL Query Analyzer. To do so, follow these steps:
  1. Point to Start, point to the Programs menu.
  2. Click Microsoft SQL Server, and then click Query Analyzer.
  3. Log on to your Server with either your Microsoft Windows NT account or your SQL Server account.
  4. On the Query menu, click Change Database, select your previous Project Central Database, and then click OK.

    Or, on the Tool bar, select your Project Central Database from the drop down list.
  5. On the File menu, in the Query Analyzer of SQL, click Open.
  6. In the Look In drop down list, select your Project 2000 CD, and then drill down to the following path: \PJCNRL\Isapi\1033.
  7. Open the first script Crttable.sql.
    Note If you initially created your database, you must modify the Crttable.sql file so that it references the database that you created by commenting out the following by entering dashes:

    --CREATE DATABASE Project_CentralDB
    --go
  8. You can now run the first script, by selecting Execute on the Query menu or by pressing F5.
  9. After Details are published in the Results pane, you are now ready to complete your database by executing the last two scripts (in order):

    Insdefsq.sql
    Insdefsi.sql

If you are using Oracle, see the Svrestup.htm file for information about how to re-create your database to correct this error.
Modification Type:MajorLast Reviewed:4/23/2003
Keywords:kbprb kbbug KB276455
©2002 Microsoft Corporation. All rights reserved.