You can create the Project Server database manually by using a Microsoft SQL Server 2000 script provided on the Project Server 2003 CD. Use this procedure if you do not want the database to be created by the Project Server Setup program.

Running this script requires a SQL Server login that is a member of the Systems Administrator role on the computer on which you are creating the database. It is also possible to use the SQL Server sa account for this purpose.

 Note   It is recommended that you run the scripts on the computer on which you are creating the database.

To create the Project Server database

1. In SQL Server 2000 Enterprise Manager, create a new database for use with Project Server 2003.
2. In Microsoft Windows Explorer, browse to the Support folder on the Project Server 2003 CD.
3. In the Support folder, copy the Database folder to a location on your database server.
4. Open a command prompt window, and then browse to the Database folder where you copied it locally.
5. Run Setupdb.cmd by using the following syntax:

   SETUPDB.cmd <SQL ServerName> <DatabaseName> <UserName> <Password> NOPAUSE
   

   For example,

   Setupdb.cmd PROJSQL2003 ProjectServer MyAccount hello NOPAUSE
   

    Note   If you omit the UserName and Password parameters, the script will use NTLM authentication.
   
   NOPAUSE is an optional parameter that will cause setupdb.cmd to return to the command prompt after completion.

6. Using SQL Server Query Analyzer and connecting with your login account, run PSRoles.sql from within the Project Server database context.

   This script creates the two database roles needed by the Project Server logins: MSProjectServerRole and MSProjectRole.

7. Using SQL Server Enterprise Manager, go to the Security folder, select Login, and create the following two logins: MSProjectServerUser and MSProjectUser. Be sure to use SQL Server authentication and to select the new database on the Database Access tab.
8. On the Database Access tab, assign the MSProjectServerRole role to the MSProjectServerUser login, and then assign the MSProjectRole role to the MSProjectUser login.

When the script finishes successfully, partition the database if necessary, and then install Project Server 2003 and connect to the new database during Project Server Setup.