Microsoft KB Archive/276455

= PRJ2000: No Names Appear in Dropdown Lists in Microsoft Project Central =

Article ID: 276455

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Project 2000 Standard Edition

-



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 -P -I Crttable.sql

osql -U -P -d  -i Insdefsq.sql

osql -U -P -d  -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.
 * 1) On the File menu, in the Query Analyzer of SQL, click Open.
 * 2) In the Look In drop down list, select your Project 2000 CD, and then drill down to the following path: \PJCNRL\Isapi\1033.
 * 3) 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
 * 1) You can now run the first script, by selecting Execute on the Query menu or by pressing F5.
 * 2) 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.

Keywords: kbprb kbbug KB276455

-

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

© Microsoft Corporation. All rights reserved.