Browse to Cumulative update package 9 for SQL Server 2005 Service Pack 2 (http://support.microsoft.com/kb/953752) in the Microsoft Knowledge Base.

At the top of the Cumulative update package 9 for SQL Server 2005 Service Pack 2 page, click View and request Hotfix Downloads.

On the Terms and Conditions page, review the Agreement for Microsoft Services, and then click I Accept.

On the Hotfix Request page, navigate to step 1, and then select the following components:.

• SQLNCLI

• SQLServer2005_ADOMD

• SQLServer2005_ASOLEDB9

• SQLServer2005_XMO

On the Hotfix Request page, navigate to step 2, and enter your e-mail address in the boxes provided. You will need to read the displayed picture characters and type them in the Type the characters text box to proceed.

Important:
The Hotfix Request page auto-detects the architecture of the computer from which you are connecting. If you want the 64-bit hotfix, you must connect to the page from a 64-bit operating system. Conversely, if you want the 32-bit hotfix, you must connect to the page from a 32-bit operating system.

Click Request Hotfix to request the SQL Server 2005 CU9 update.

The Hotfix Confirmation page is displayed and the CU9 update download link and instructions are mailed to the e-mail address that you specified.

Open your e-mail client for the e-mail address you specified and open the e-mail message from hotfix@microsoft.com with the subject "Hotfix download link you requested."

In the Hotfix e-mail message, scroll to the bottom and review the package information. It should list the following:

• KB Article Number(s): 953752

• Language: All (Global)

• Platform: i386

• Location: <URL provided here>

• Password: <Password provided here>

• Password Changes On: <Date provided here>

• Next Password: <Password provided here>

In the body of the hotfix e-mail message, click the location link as described above. This will open a file-download dialog box that lists the name of the self-extracting zip file.

In the File Download dialog box, select Save, and then save the .exe file to your desktop.

Navigate to your desktop and run the .exe file that you just saved. You will need the password provided in the hotfix e-mail message.

Proceed through the Microsoft Self-Extractor wizard and enter the hotfix password when prompted. Save the extracted files to your desktop.

Two files are extracted: the .msi file and a text file. Review the text file and then run the .msi file as described in the next procedure.

Run all CU9 update *.msi files on all computers hosting PerformancePoint Server components. This includes the PerformancePoint Add-In for Excel but does not include PerformancePoint Planning Business Modeler.

Important:
You must install both SQLServer2005_ASOLEDB9 and SQLNCLI on all computers hosting SQL Server 2008 Analyisys Services.

Proceed through the installation wizard, accepting all default options.

When the installation wizard finishes, click Finish to exit.

After the CU9 update has been applied, proceed to the PerformancePoint Server SP2 installation.

Install SQL Server 2008 as described in detail in How to: Install SQL Server 2008 (Setup) (http://technet.microsoft.com/en-us/library/ms143219.aspx).

When selecting database collation, choose Latin1_General Case-Insensitive Accent-Sensitive.

Complete all SQL Server 2008 installation steps, including all updates and reboots before beginning the PerformancePoint Planning Server installation.