Database upgrade for Project Server SP1

[Terry Van Gundy]

Encountered an error when attempting to upgrade Project
Server database prior to application of SP1. Using the
Upgdb111.cmd command file locally on the project SQL
server and it generated errors.....
Not a valid Project Server 2003 Database!
Project schema tables not found in this Project Server
database
Web schema tables not found in this Project Server database
View schema tables not found in this Project Server
database
This is only project server db on the SQL server

 

[Gary L. Chefetz \(MVP\)]

What command line did you use?

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-

 

[Terry Van Gundy]

Command Line used:
Upgdb111.cmd SQLserverName DatabaseName"
Logged in locally with Admin account.
Also attempted with same construct above using SQL server
authentication with "sa" account that has full permissions
to Project Server database.