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.

OLAP Database Created Outside of Project Server

Failed to build the OLAP Cubes. Error: Analysis Services Session Failed with the following Error: Cannot Overwrite an OLAP Database Created Outside of Project Server or by Another Project Server Site


Issue: Analysis Database for OLAP got corrupted
Resolution:
1) Login to Analysis Services Machine as Administrator
2) Start All Programs Microsoft SQL Server 2005 SQL Server Management Studio
3) On Server Type Select Analysis Services Enter Correct Server Name Click Connect
4) Expand Analysis Server Databases "DBName" (Cube Name)
5) Right Click and Delete
6) Re-build the OLAP cube via Project Web Access

Announcing the Infrastructure Update for Office Servers

Download Links:

WSS 3.0 Update
http://www.microsoft.com/downloads/details.aspx?FamilyId=256CE3C3-6A42-4953-8E1B-E0BF27FD465B&displaylang=en
MOSS Update
http://www.microsoft.com/downloads/details.aspx?familyid=3811C371-0E83-47C8-976B-0B7F26A3B3C4&displaylang=en

On July 15th, 2008 Microsoft announced the availability of the Infrastructure Update for Office Servers. The Infrastructure Update for Office Servers is a set of updates to improve platform performance and contain several customer driven fixes. The updates are applicable to Microsoft Office SharePoint Server 2007, Windows SharePoint Services 3.0, Microsoft Search Server 2008 & Microsoft Search Server 2008 Express, Microsoft Office Project Server 2007 and Microsoft Office Project 2007.

Info from link below:

http://blogs.msdn.com/project/archive/2008/07/15/announcing-the-infrastructure-update-for-office-servers.aspx


Infrastructure Update for Windows SharePoint Services 3.0 (KB951695)
http://support.microsoft.com/kb/951695
Infrastructure Update for Microsoft Office Servers (KB951297)
http://support.microsoft.com/kb/951297
Infrastructure Update for Microsoft Office Project 2007 (KB951547)
http://support.microsoft.com/kb/951547
Infrastructure Update for Microsoft Office Project 2007 (KB953751)
http://support.microsoft.com/kb/953751
Infrastructure Update for Windows SharePoint Services 3.0 (KB953749)
http://support.microsoft.com/kb/953749