Install PerformancePoint Monitoring Server with SQL Server 2008

Updated: 2010-04-29

This article covers the information required to install PerformancePoint Monitoring Server Service Pack 3 (SP3) for use with Microsoft SQL Server 2008. The recommended order of installation is as follows:

  1. Install SQL Server 2005 Cumulative Update 9 or SQL Server 2005 Service Pack 3 (SP3) on all computers hosting Monitoring Server

  2. Install SQL Server 2008

  3. Install PerformancePoint Monitoring Server 2007 RTM

    Important

    Do not configure PerformancePoint Monitoring Server until after SP2 has been installed.

  4. Install PerformancePoint Monitoring Server SP3

  5. Configure PerformancePoint Monitoring Server

Installing SQL Server 2005 Cumulative Update 9 on computers hosting PerformancePoint Monitoring Server

PerformancePoint Monitoring server 2007 SP2 requires SQL Server 2005 client component software installed on all computers hosting Monitoring Server components. The components allow PerformancePoint Monitoring Server SP2 to communicate with SQL Server 2008 databases.

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

  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 then 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 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 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 the PerformancePoint Server SP2 installation.

Download SQL Server 2005 Service Pack 3

SQL Server 2005 Service Pack 3 is available on Microsoft TechNet at Feature Pack for Microsoft SQL Server 2005 - December 2008. If you already have SQL Server 2005 CU9 installed, you do not need to install SQL Server 2005 SP3.

Installing SQL Server 2008

Use the following procedure to install SQL Server 2008 for use with PerformancePoint Server 2007 SP2.

Install SQL Server 2008

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

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

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

Install PerformancePoint Server 2007 RTM

PerformancePoint Monitoring Server 2007 RTM can now be installed and connected to SQL Server 2008. Detailed information for installing PerformancePoint Monitoring Server can be found in the Deployment Guide for Monitoring Server.

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 3 (SP3). In order to successfully install SP3, you will have to run the following database update command script: AppDBpreSP2Update. This script can be found here: https://go.microsoft.com/fwlink/?LinkID=136749. After running the script, you will be able to upgrade to SP3. A future cumulative update will remove the need for this script.

Warning

Do not run the PerformancePoint Monitoring Server Configuration Manager; this will be done after SP3 is installed. You will be unable to specify a SQL 2008 database server until after SP3 has been installed.

Install PerformancePoint Server 2007 SP3

PerformancePoint Monitoring Server SP3 updates the PerformancePoint Monitoring Server Configuration Manager. Run the Monitoring Server Configuration Manager after SP3 has been installed. To install PerformancePoint Monitoring Server SP3, see Service Pack 3 for Microsoft Office PerformancePoint Server 2007.

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.