Project Server 2003

R

Ranga

I want to restore the SQL Database backup of MS Project
2002 on MS Project Server 2003. What is the best method to
do this?
I just restored the MS Project 2002 SQL database on MS
Project Server 2003, and i am not able to log in as
administrator, i was able to login before i did the
restore.

Thanks,
Ranga
 
N

Nico Oosthuysen

Hi Ranga,

You cannot simply restore the database, and then hope project 2003 will be
able to connect to it - you need to upgrade the database to the newer
version. To do this you need to run the upg10db.cmd script from the project
server 2003 cd:

1. Insert the project 2003 cd
2. open up a command prompt, and browse to the directory:
<cddrive>:\support\database"
3. run the command upg10db.cmd, in the format:

"Upg10DB.cmd [ServerName] [DatabaseName] [Login] [Password]" where:
[ServerName] = Database Server Name
[DatabaseName] = database name (defaults to "ProjectServer")
[Login] = SQL Server login
[Password] = Password for the SQL Server login

To use a use a trusted connection leave [Login] and [Password] blank.

this will then upgrade your database for use with ps 2003. Just ensure that
you have made decent backups before performing operations like these!
 
Top