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
Notes
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.
