Assumptions:
- You have installed Project Server on New Machine to a point where you have Sharepoint Central Administration, Web Application on Port 80, Web Application for SSP and Project Application Service is started.
- Make Sure you same project server service pack and patches installed on new server
- You have backed and restored project server database to new server
- You have backed and restore Content Database for Port 80 (Assuming your project server work space was on port 80)
Steps:
- Navigate to Start » All Programs » Administrative Tools » SharePoint 3.0 Central Administration
Click on Operations > Under Topology and Services > Click on Services on Server > Select the Option Project Application
- Under Shared Service Administration Click on SharedServices1 (Name could be different)
- Click on Project Web Access Sites
- Click on Create Project Web Access
- Make Sure you select the same "Project Web Access Path" if you want to RESTORE AND RELINK SharePoint workspace. My Scenario was PWA.
- Enter the account info for Administrator Account and Primary Database Server
- Enter the name of Published Database, Draft Database, Archive database and Reporting Database (restored databases)
- Click on refresh status after few minutes
- The Site should be provisioned
- Click on the site just to make sure project web access is working
- Click on Workspace "The PAGE not found" (EXPECTED)
- Now Create a new web application
- Navigate back to central administration > application management > Under SharePoint Web Application Management Click on Create or Extend Web Application
- Create New Web-Application on Port 81 *Can be any port except 80
- Once the Web application is created on port 81 > Navigate back to central administration > application management > Under SharePoint Web Application Management Click on Content databases
- Change the Web-Application to http://servername:81/
- Remove the content database of port 81 (Make Sure you are removing the content database of correct web application)
- Click on Database name and then click on Remove Content Database > Click Ok
- Add Content Database of Port 80 from Previous Server (I did restored the database as "OLD") to this web application on Port 81
- Download Project Server Resource kit for project server 2007 from Microsoft.com
- Extract it to C:\ResourceKit
- Start > Run > Cmd
- Browse to C:\ResourceKit
- Type
ReLinkAllWSSSites.exe http://servername:81 http://servername/pwa

27. Type Browse to PWA (http://serverName/PWA) you should see all Projects and their SharePoint sites.