• Article

Update SQL Server 2005 client components with Cumulative Update 9

Updated: 2009-10-15

Microsoft Office PerformancePoint Server 2007 requires SQL Server 2005 Cumulative Update 9 (CU9) to communicate with Microsoft SQL Server 2008. This update affects only the SQL Server 2005 client components and redistributable files. This article covers the process to download and install SQL Server CU9 for all computers where PerformancePoint Server is installed.

Alternately, you can install SQL Server 2005 Service Pack 3 (SP3) instead of the SQL Server 2005 CU9 update. SQL Server 2005 SP3 contains the hotfixes that were included in cumulative update packages for SQL Server 2005 Service Pack 2 from cumulative update package 1 to cumulative update package 9. SQL Server 2005 Service Pack 3 is available on Microsoft TechNet at What’s New in SQL Server 2005 SP3. However, if you already have SQL Server 2005 CU9 you do not need to install SQL Server 2005 SP3.

Note

If you upgrade from SQL Server 2005 CU10 or CU11, then you must apply a post-SP3 cumulative update after upgrading to SP3 to get all of the fixes. The post-SP3 update is available on the Microsoft Help and Support site Cumulative update package 1 for SQL Server 2005 Service Pack 3.

Downloading and installing SQL Server 2005 CU9

Use the following procedures to download and install CU9.

Download SQL Server 2005 CU9

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

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

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

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

    • SQLNCLI

    • SQLServer2005_ADOMD

    • SQLServer2005_ASOLEDB9

    • SQLServer2005_XMO

  5. 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 enter 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.

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

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

  8. 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."

  9. 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>

  10. 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.

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

  12. 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.

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

  14. 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.

Install SQL Server 2005 CU9

  1. Run all CU9 update .msi files on all computers hosting PerformancePoint Monitoring Server components. This includes the computers hosting the Planning and Monitoring Application pools, typically the Web front-end servers. The CU9 .msi files must also be installed on the computer hosting the PerformancePoint Add-In for Excel. You do not need to install the CU9 .msi files on the computer hosting PerformancePoint Planning Business Modeler.

    Important

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

  2. Proceed through the installation wizard, accepting all default options.

  3. When the installation wizard finishes, click Finish to exit.

  4. After the CU9 update has been applied, proceed to: Update Planning Server with Service Pack 3.

Download this book

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

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