In this scenario, PerformancePoint Planning and Monitoring Servers are updated to SP2 without altering the existing SQL Server 2005 environment. SP2 is installed on all computers hosting PerformancePoint Planning and Monitoring components and services, including client computers hosting PerformancePoint Planning Business Modeler and the PerformancePoint Add-in for Excel. For this scenario, follow the instructions in these articles:

Important:

If you are currently running PerformancePoint Server version 3.0.4102.00 or a later version, you will receive an error when you try to upgrade to Service Pack 2 (SP2). In order to successfully install SP2, you will have to run the following database update command script: AppDBpreSP2Update. This script can be found here: http://go.microsoft.com/fwlink/?LinkID=136749. After running the script, you will be able to upgrade to SP2. A future cumulative update will remove the need for this script.

1. Update Planning Server with Service Pack 2

2. Update Monitoring Server with Service Pack 2

In this scenario, SQL Server 2005 is updated to SQL Server 2008. SQL Server 2005 Cumulative Update 9 (CU9) is applied to all computers hosting PerformancePoint Server components and services, including client computers hosting PerformancePoint Planning Business Modeler and the PerformancePoint Add-in for Excel. CU9 is also installed on computers hosting SQL Server 2008 Analysis Services. Service Pack 2 is installed on all computers hosting PerformancePoint Planning and Monitoring Server components and services, including Planning Business Modeler and the PerformancePoint Add-in for Excel. For this scenario, follow the instructions in these articles:

1. Update SQL Server 2005 client components with Cumulative Update 9

2. Upgrade SQL Server 2005 to SQL Server 2008 with PerformancePoint Planning Server

3. Upgrade SQL Server 2005 to SQL Server 2008 with PerformancePoint Monitoring Server

4. Update Planning Server with Service Pack 2

5. Update Monitoring Server with Service Pack 2

In this scenario, SQL Server 2008 is installed on newly configured computers. SQL Server Cumulative Update 9 (CU9) is applied to all computers hosting PerformancePoint Server components and services including client computers hosting PerformancePoint Planning Business Modeler and the PerformancePoint Add-in for Excel. CU9 is also installed on computers hosting SQL Server 2008 Analysis Services. PerformancePoint Planning and Monitoring Servers are installed to a newly configured computer or computers. Service Pack 2 is installed on all computers hosting PerformancePoint Planning and Monitoring Server components and services including Planning Business Modeler and the PerformancePoint Add-in for Excel. For this scenario, follow the instructions in these articles:

1. Update SQL Server 2005 client components with Cumulative Update 9

2. Install PerformancePoint Planning Server with SQL Server 2008

3. Install PerformancePoint Monitoring Server with SQL Server 2008

4. Update Planning Server with Service Pack 2

5. Update Monitoring Server with Service Pack 2

This topic is included in the following downloadable book for easier reading and printing:

• Planning Server Deployment Guide for PerformancePoint Server 2007

• Monitoring Server Deployment Guide for PerformancePoint Server 2007

See the full list of available books at Downloadable content for PerformancePoint Monitoring Server .

Other Resources