Deploy Service Pack 1 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 1 (SP1) 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.
Important
Please be aware that Office Project Server 2007 Service Pack 2 (SP2) is also currently available. Note that all fixes for Office Project Server 2007 SP1 are available in Office Project Server 2007 SP2. For information about deploying Office Project Server 2007 SP2, see Deploy Service Pack 2 for Office Project Server 2007.
Office Project Server 2007 Service Pack 1 is available in 2007 Microsoft Office Servers Service Pack 1 (SP1) (https://go.microsoft.com/fwlink/?LinkID=105636\&clcid=0x409). These files include updates for the following 2007 Microsoft Office System server products:
Microsoft Office SharePoint Server 2007
Office Project Server 2007
Microsoft Office Forms Server 2007
Office Project Server 2007 is built on Windows SharePoint Services 3.0. Before installing 2007 Microsoft Office Servers Service Pack 1, you must first install SP1 for Windows SharePoint Services 3.0; this article documents both installations. However, for detailed information about applying Windows SharePoint Services 3.0 SP1 to various deployment scenarios, see Deploy software updates for Windows SharePoint Services 3.0.
Before you begin
Before you install the Windows SharePoint Services 3.0 SP1 and 2007 Microsoft Office Servers SP1, take these recommended actions:
Back up the databases before you start the 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, end users will not be able to browse the Web sites 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
Note
If you chose Basic installation (single server with Microsoft SQL Server Desktop Engine) when you installed Office Project Server 2007, you do not need to follow the process and procedures in this article.
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
Important
You cannot use Automatic Updates to install any of the required service packs on Office Project Server 2007, on Windows SharePoint Services 3.0, or on language packs in a server 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 SP1, you must perform the following steps:
On all servers in the farm, install the Windows SharePoint Services 3.0 SP1 files, but do not run the SharePoint Products and Technologies Configuration Wizard.
On all servers in the farm, install the 2007 Microsoft Office Servers SP1 files, but do not run the SharePoint Products and Technologies Configuration Wizard.
On one server in the farm (preferably the one hosting the Central Administration site), run the SharePoint Products and Technologies Configuration Wizard to complete the installation on that server.
Run the SharePoint Products and Technologies Configuration Wizard on all remaining servers on 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.
Note
For information on how to use console sessions, read the Microsoft Knowledge Base article How to connect to and shadow the console session with Windows Server 2003 Terminal Services (https://go.microsoft.com/fwlink/?LinkID=98317&clcid=0x409).
Install SP1 on Office Project Server 2007 in a farm deployment
Disconnect users from the server farm by stopping the World Wide Web Publishing service (w3svc) on all Web servers.
Download Windows SharePoint Services 3.0 SP1 from the Microsoft Download Center (https://go.microsoft.com/fwlink/?LinkID=105655\&clcid=0x409). 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 SP1 (64-bit)
wssv3sp1-kb936988-x64-fullfile-en-us.exe
Windows SharePoint Services 3.0 SP1 (32-bit)
wssv3sp1-kb936988-x86-fullfile-en-us.exe
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 SP1, do not run the SharePoint Products and Technologies Configuration Wizard. Start the wizard only after installing all SP1 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.
Download 2007 Microsoft Office Servers SP1 from the Microsoft Download Center (https://go.microsoft.com/fwlink/?LinkID=105636\&clcid=0x409). Depending on whether your system is 64-bit or 32-bit, the files are:
System File Office SharePoint Server 2007 SP1 (64-bit)
officeserver2007sp1-kb936984-x64-fullfile-en-us.exe
Office SharePoint Server 2007 SP1 (32-bit)
officeserver2007sp1-kb936984-x86-fullfile-en-us.exe
On the same server on which you installed Windows SharePoint Services 3.0 SP1, run the file to start the 2007 Microsoft Office Servers SP1 installation.
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.
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.
Go to each server in your Office Project Server 2007 farm and repeat steps 2-7 to install both SP1 files.
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 both service packs to each server, remember to click Cancel on the SharePoint Products and Technologies Configuration Wizard Welcome page.
After installing the SP1 files on each server in the farm, go to each application server and stop the following services (if available):
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.
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.
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.
On the Configuration Successful page, click Finish.
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.
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 that 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
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 you install the service pack, review the upgrade log file and open the SharePoint Central Administration Web site to verify that the installation has been successful by using the procedure outlined in the table that follows. Next, you should verify that the updates to the Web applications were successful.
The easiest method to see if Office Project Server 2007 is updated to SP1 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
On the Windows 2003 Server on which you are checking the Office Project Server 2007 version, click Start, click Control Panel, and then click Add or Remove Programs.
On the Add or Remove Programs page, in the list of Currently installed programs, click Microsoft Office Project Server 2007.
Under Microsoft Office Project Server 2007, click Click here for support information.
In the Support Info screen, check the Version number. If SP1 for Office Project Server 2007 is installed on this server, the version number should be 12.0.6219.1000.
Another way to determine whether Office Project Server 2007 has been updated to SP1 is to query the VERSIONS table in one of the Office Project Server 2007 databases.
View Project Server version information in the Versions table in a Project Server 2007 database
On the computer running the instance of SQL Server containing the Office Project Server 2007 databases, open SQL Server Management Studio.
Click New Query.
Choose one of the Office Project Server 2007 databases (Draft, Published, Reporting, or Archive) from the Available Databases list.
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.6218.1000.
For information about verifying the installation and known issues, refer to Deploy software updates for Windows SharePoint Services 3.0.
Update Office Project Server 2007 language packs
Note
You must install any required Windows SharePoint Services 3.0 Language Pack Service Pack 1 (SP1) updates before installing Office Project Server 2007 Language Pack SP1 updates. For more information about installing WSS Language Pack SP1 updates, see Deploy software updates for Windows SharePoint Services 3.0.
Office Project Server 2007 language pack updates are available in 2007 Microsoft Office Servers Language Pack Service Pack 1 (SP1). This service pack contains updates for the following Office Server language packs:
Office Forms Server 2007 Language Pack
Office Project Server 2007 Language Pack
Office SharePoint Server 2007 Language Pack
2007 Microsoft Office Servers Language Pack Service Pack 1 will detect any required language packs on the server and will install them as needed. For more information about installing 2007 Microsoft Office Servers Language Pack Service Pack 1, see Deploy software updates for Office SharePoint Server 2007.
Deployment considerations for language pack updates
When installing 2007 Microsoft Office Servers Language Pack Service Pack 1 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:
On all servers in the farm, install the Windows SharePoint Services 3.0 SP1 but do not run the SharePoint Products and Technologies Configuration Wizard.
On all servers in the farm, install 2007 Microsoft Office Servers SP1, but do not run the SharePoint Products and Technologies Configuration Wizard.
On all servers in the farm, install Windows SharePoint Services 3.0 Language Pack SP1, but do not run the SharePoint Products and Technologies Configuration Wizard.
On all servers in the farm, install Office SharePoint Server 2007 Language Pack Service Pack 1, but do not run the SharePoint Products and Technologies Configuration Wizard.
On one server in the farm (preferably the one hosting the Central Administration site), run the SharePoint Products and Technologies Configuration Wizard to complete the installation on this server.
Run the SharePoint Products and Technologies Configuration Wizard on all remaining servers on the farm.
See Also
Concepts
Deploy Project Server 2007 updates
Deploy Service Pack 2 for Office Project Server 2007
Checklist for deploying Project Server 2007 updates
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)