Tuesday, October 21, 2008

Steps to Move Project Server 2007 from One Environment to Another Including WorkSpace

Assumptions:

  1. 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.
  2. Make Sure you same project server service pack and patches installed on new server
  3. You have backed and restored project server database to new server
  4. You have backed and restore Content Database for Port 80 (Assuming your project server work space was on port 80)

Steps:

  1. Navigate to Start » All Programs » Administrative Tools » SharePoint 3.0 Central Administration

  2. Click on Operations > Under Topology and Services > Click on Services on Server > Select the Option Project Application

  3. Make Sure Project Application Service is started

  4. Under Shared Service Administration Click on SharedServices1 (Name could be different)
  5. Click on Project Web Access Sites
  6. Click on Create Project Web Access
  7. Make Sure you select the same "Project Web Access Path" if you want to RESTORE AND RELINK SharePoint workspace. My Scenario was PWA.
  8. Enter the account info for Administrator Account and Primary Database Server
  9. Enter the name of Published Database, Draft Database, Archive database and Reporting Database (restored databases)
  10. Click on refresh status after few minutes




  11. The Site should be provisioned
  12. Click on the site just to make sure project web access is working
  13. Click on Workspace "The PAGE not found" (EXPECTED)
  14. Now Create a new web application
  15. Navigate back to central administration > application management > Under SharePoint Web Application Management Click on Create or Extend Web Application
  16. Create New Web-Application on Port 81 *Can be any port except 80



  17. 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
  18. Change the Web-Application to http://servername:81/




  19. Remove the content database of port 81 (Make Sure you are removing the content database of correct web application)
  20. Click on Database name and then click on Remove Content Database > Click Ok



  21. Add Content Database of Port 80 from Previous Server (I did restored the database as "OLD") to this web application on Port 81







  22. Download Project Server Resource kit for project server 2007 from Microsoft.com
  23. Extract it to C:\ResourceKit
  24. Start > Run > Cmd
  25. Browse to C:\ResourceKit
  26. 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.