Deploy Service Pack 2 for Office Project Server 2007

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

Topic Last Modified: 2016-11-14

This article provides guidance to IT professionals managing the Service Pack 2 (SP2) update to a Microsoft Office Project Server 2007 deployment. Issues covered include updating basic and farm deployments, preparing for installation, starting and finalizing the installation, verifying the installation, as well as language pack considerations.

Office Project Server 2007 SP2 is available in 2007 Microsoft Office Servers Service Pack 2 (SP2) (https://go.microsoft.com/fwlink/?LinkId=148351). These files include updates for the following 2007 Microsoft Office System server products:

• Microsoft Office SharePoint Server 2007

• Office Project Server 2007

• Microsoft Office Groove Server 2007

• Microsoft Office Forms Server 2007

For detailed information about 2007 Microsoft Office Servers SP2, go here (https://go.microsoft.com/fwlink/?LinkId=149621).

Before you begin

Before you install Windows SharePoint Services 3.0 SP2 and 2007 Microsoft Office Servers SP2, take these recommended actions:

• Back up the databases before you start either service pack installation.

  For more information about how to perform backups, read Prepare to back up and restore a farm (Windows SharePoint Services 3.0).

• Stop the World Wide Web Publishing Service on all the Web servers to disconnect all the users from the server farm. In server farms with multiple front-end Web servers, users will not be able to browse Websites when files and databases have been updated on the first front-end Web server, while the other Web servers still contain previous files and databases.

• Verify that all Windows SharePoint Services upgrade jobs are complete. You can check for in-progress upgrade processes in the Timer Job Status page on the SharePoint Central Administration Web site. For more information, see Deploy software updates for Windows SharePoint Services 3.0.

  Note

  Deploy software updates for Windows SharePoint Services 3.0 contains additional recommendations. Since Office Project Server 2007 is built on Windows SharePoint Services 3.0, we advise that you also see this article for additional recommendations before updating your Office Project Server 2007 deployment.

Update a Basic installation

If you have Automatic Updates enabled for Basic installation, your computers are updated automatically.

The software update procedure checks the registry and blocks automatic installation on any Web server that does not contain the value singleserver in the SERVERROLE key.

To determine if you need to manually download and install the software update, use a registry editor to verify the value in the following key: HKLM\Software\Microsoft\Shared Tools\web server extensions\12.0\WSS\SERVERROLE

If you do not have Automatic Updates enabled, you can use the Microsoft Update Web site to install the software updates. After the software update is installed, the SharePoint Products and Technologies Configuration Wizard runs automatically while updating the SharePoint Products and Technologies databases. The SharePoint Products and Technologies Configuration Wizard will not prompt the user for input or display any notifications while the wizard is running.

Update a farm deployment

For Office Project Server 2007 farm deployments, visit the Microsoft download center to download and then install the service pack on each server in your farm.

Also, because Office Project Server 2007 is built on Windows SharePoint Services 3.0, the service packs for both products will need to be applied to all servers in the farm.

Installation steps

To update a Office Project Server 2007 server farm deployment with SP2, you must perform the following steps:

1. On all servers in the farm, install the Windows SharePoint Services 3.0 SP2 files, but do not run the SharePoint Products and Technologies Configuration Wizard.

2. On all servers in the farm, install the 2007 Microsoft Office Servers SP2 files, but do not run the SharePoint Products and Technologies Configuration Wizard.

3. On one server in the farm (preferably the server hosting the Central Administration site), run the SharePoint Products and Technologies Configuration Wizard to complete the installation on that server.

4. Run the SharePoint Products and Technologies Configuration Wizard on all remaining servers in the farm.

   Note

   If you have Office Project Server 2007 language packs that you would like to update as well, see the section "Deployment considerations for language pack updates" in this article.

We recommend that you use SharePoint Central Administration v3 application pool account credentials to run the SharePoint Products and Technologies Configuration Wizard. If you then use a different account to install the service pack, that account must be a domain account with the following rights and permissions:

• Member of the Administrators group on the Web server computer

• Member of the Administrators group on the SQL Server computer

You can install the service pack by logging on to the server directly or by connecting through a terminal services console session.

Install SP2 on Office Project Server 2007 in a farm deployment

1. Disconnect users from the server farm by stopping the World Wide Web Publishing service (w3svc) on all Web servers.

2. Download Windows SharePoint Services 3.0 SP2 from the Microsoft Download Center (https://go.microsoft.com/fwlink/?LinkId=149241). You will need to install the service pack files on each server in your Office Project Server 2007 farm. Depending on whether your system is 64-bit or 32-bit, the files are:

   System	File
   Windows SharePoint Services 3.0 SP2 (64-bit)	wssv3sp2-kb953338-x64-fullfile-en-us.exe
   Windows SharePoint Services 3.0 SP2 (32-bit)	wssv3sp2-kb953338-x86-fullfile-en-us.exe

3. On a server in the farm, run the file. At the Microsoft Software License Terms screen, read the terms and click Click here to accept the Microsoft Software License Terms. Click Continue to install the update files.

   Important

   After installing the files for Windows SharePoint Services 3.0 SP2, do not run the SharePoint Products and Technologies Configuration Wizard. Start the wizard only after installing all SP2 files to the server.

   At the end of the service pack installation, the SharePoint Products and Technologies Configuration Wizard Welcome page displays. Click Cancel to exit the SharePoint Products and Technologies Configuration Wizard.

4. Download 2007 Microsoft Office Servers SP2 from the Microsoft Download Center (https://go.microsoft.com/fwlink/?LinkId=148351). Depending on whether your system is 64-bit or 32-bit, the files are:

   System	File
   Office SharePoint Server 2007 SP2 (64-bit)	officeserver2007sp2-kb953334-x64-fullfile-en-us.exe
   Office SharePoint Server 2007 SP2 (32-bit)	officeserver2007sp2-kb953334-x86-fullfile-en-us.exe

5. On the same server on which you installed Windows SharePoint Services 3.0 SP2, run the file to start the 2007 Microsoft Office Servers SP2 installation.

6. Read the terms on the Microsoft Software License Terms screen, and then click Click here to accept the Microsoft Software License Terms. Click Continue to install the update files.

7. At the end of the service pack installation, the SharePoint Products and Technologies Configuration Wizard Welcome page displays. Click Cancel. Do not run the SharePoint Products and Technologies Configuration Wizard at this time.

8. Go to each server in your Office Project Server 2007 farm and repeat steps 2-7 to install Windows SharePoint Services 3.0 SP2 and Microsoft Office Servers SP2.

   You must run setup to install new binary files for every server in your server farm. If you have multiple servers in your server farm, run setup on the other servers now.

   Note

   After installing Windows SharePoint Services 3.0 SP2 and Microsoft Office Servers SP2 to each server, remember to click Cancel on the SharePoint Products and Technologies Configuration Wizard Welcome page.

9. After installing Windows SharePoint Services 3.0 SP2 and Microsoft Office Servers SP2 on each server in the farm, go to each application server. Check whether the following services (if available) are running, and if so, stop them:

   • Microsoft Office Project Server Events service

   • Microsoft Office Project Server Queue service

   If the services are not stopped, a reboot may be required at completion of setup.

10. Use the server that hosts the Central Administration Web site to finalize the installation.

    Note

    We recommend that you finalize the software update installation first on the application server hosting the Central Administration Web site, then on the other application servers, and then on the front-end Web servers.
    If you host your Central Administration Web site on a front-end Web server, finalize the software update installation instead on that front-end Web server, then the application servers, and finally on the remaining front-end Web servers.

    In a server farm with multiple servers, you can determine this server through the Central Administration page by clicking on Operations, clicking on Servers in Farm, and then verifying which server has Central Administration in the Services Running column.

11. On the server you selected in the previous step, run the SharePoint Products and Technologies Configuration Wizard to complete the installation. To run the SharePoint Products and Technologies Configuration Wizard, click Start, click Administrative Tools, and then click SharePoint Products and Technologies Configuration Wizard.

12. On the Configuration Successful page, click Finish.

13. After you have finished updating the server that hosts the Central Administration Web site, make sure that the software update installation was successful by following the procedures in the "Verify the installation" section of this article.

14. Continue finalizing the installation on the remaining computers in the server farm, one at a time, by running the SharePoint Products and Technologies Configuration Wizard as described in steps 11 and 12.

    Note

    It is important that the SharePoint Products and Technologies Configuration Wizard perform its configuration procedures on only one computer at a time. The only exception is the instance in which you have detached your content databases and upgraded them before you reattach them to the server farm. For more information, see the Microsoft TechNet article Deploy software updates for Windows SharePoint Services 3.0

15. When the service pack installation and configuration is complete on all the servers in the server farm, make the Web servers available to users by manually starting the World Wide Web Publishing Service on each server on which you manually stopped the service.

Verify the installation

After completing the service pack installation, review the upgrade log file. Then open the SharePoint Central Administration Web site to verify that the installation has been successful by using the procedure outlined in the table on the Web site. Next, you should verify that the updates to the Web applications were successful.

The easiest method to see whether Office Project Server 2007 is updated to SP2 on a server is to view the version of Project Server through Add/Remove Programs.

View Project Server version information in Add or Remove Programs

1. On the Windows 2003 Server computer on which you are checking the Office Project Server 2007 version, click Start, click Control Panel, and then click Add or Remove Programs.

2. In the list of Currently installed programs, click Microsoft Office Project Server 2007.

3. Under Microsoft Office Project Server 2007, click Click here for support information.

4. In the Support Info screen, check the version number. If SP2 for Office Project Server 2007 is installed on this server, the version number should be 12.0.6422.1000.

Another method to see if Office Project Server 2007 is updated with SP2 is to query the VERSIONS table in one of the Office Project Server 2007 databases.

View Project Server version information through the Versions table in a Project Server 2007 database

1. On the computer running the instance of SQL Server containing the Office Project Server 2007 databases, open SQL Server Management Studio.

2. Click New Query.

3. Choose one of the Office Project Server 2007 databases (Draft, Published, Reporting, or Archive) from the Available Databases drop-down list.

4. Type select * from versions in the query window and then click Execute.

   The most recent version number in the Version field should be 12.0.6422.1000.

For information about verifying the installation and known issues, see Deploy software updates for Windows SharePoint Services 3.0.

Update Office Project Server 2007 language packs

2007 Microsoft Office Servers Language Pack SP2 contains updates for the following Office Server language packs:

• Office SharePoint Server 2007 Language Pack

• Office Project Server 2007 Language Pack

• Office Forms Server 2007 Language Pack

• Office Groove Server 2007 Language Pack

2007 Microsoft Office Servers Language Pack SP2 will detect any required language packs on the server and will install them as needed.
You can download 2007 Microsoft Office Servers Language Pack SP2, 32-bit version (https://go.microsoft.com/fwlink/?LinkId=149247) and 2007 Microsoft Office Servers Language Pack SP2, 64-bit version (https://go.microsoft.com/fwlink/?LinkId=149246) from the Microsoft Download Center.
For more information about installing 2007 Microsoft Office Servers Language Pack SP2, see Deploy software updates for Office SharePoint Server 2007.

Deployment considerations for language pack updates

When installing 2007 Microsoft Office Servers Language Pack SP2 on Office Project Server 2007 in a server farm deployment, you must install the files to each server in the farm. Install the language template pack updates to each server, and then return to one server and run the SharePoint Products and Technologies Configuration Wizard to complete installation. Finally, run the wizard for each remaining server.

The recommended order for installing the service pack updates on Office Project Server 2007 with language packs in a server farm deployment is:

1. On all servers in the farm, install the Windows SharePoint Services 3.0 SP2 but do not run the SharePoint Products and Technologies Configuration Wizard.

2. On all servers in the farm, install 2007 Microsoft Office Servers SP2, but do not run the SharePoint Products and Technologies Configuration Wizard.

3. On all servers in the farm, install Windows SharePoint Services 3.0 Language Pack SP2, but do not run the SharePoint Products and Technologies Configuration Wizard.

4. On all servers in the farm, install Office SharePoint Server 2007 Language Pack SP2, but do not run the SharePoint Products and Technologies Configuration Wizard.

5. On one server in the farm (preferably the server hosting the Central Administration site), run the SharePoint Products and Technologies Configuration Wizard to complete the installation on this server.

6. Run the SharePoint Products and Technologies Configuration Wizard on all remaining servers on the farm.

See Also

Other Resources

Deploy software updates for Windows SharePoint Services 3.0
Deploy software updates for Office SharePoint Server 2007
Office Project Server TechCenter (https://go.microsoft.com/fwlink/?LinkID=105773&clcid=0x409)