Share via


Install PerformancePoint Planning Server with SQL Server 2008

Updated: 2010-02-03

This article covers the information required to install PerformancePoint Planning 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 Service Pack 3 (SP3) software on all computers hosting PerformancePoint Planning Server components

  2. Install SQL Server 2008

  3. Install PerformancePoint Planning Server 2007 RTM

    Important

    Do not configure PerformancePoint Planning Server until after SP3 has been installed.

  4. Install PerformancePoint Planning Server SP3

  5. Configure PerformancePoint Planning Server

Installing SQL Server 2005 SP3 Feature Pack files on computers hosting PerformancePoint Planning Server components

PerformancePoint Planning Server 2007 SP3 requires SQL Server 2005 SP3 components installed on all computers hosting PerformancePoint Planning Server components. The SQL Server 2005 SP3 components allow PerformancePoint Planning Server SP3 to communicate with SQL Server 2008 database.

Download SQL Server 2005 SP3

  1. Browse to Feature Pack for Microsoft SQL Server 2005 - December 2008.

  2. On the SQL Server 2005 Feature Pack page, navigate to the instructions section, and then select the following .msi files:

    • SQLNCLI.msi (x86) or SQLNCLI_x64.msi

    • SQLServer2005_ADOMD.msi (x86) or SQLServer2005_ADOMD_x64.msi

    • SQLServer2005_ASOLEDB9.msi (x86) or SQLServer2005_ASOLEDB9_x64.msi

    • SQLServer2005_XMO.msi (x86) or SQLServer2005_XMO_x64.msi

Install SQL Server 2005 SP3

  1. Run the four SP3 .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 SP3 update has been applied, proceed to the PerformancePoint Server SP3 installation.

Installing SQL Server 2008

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

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 Planning Server installation.

Install PerformancePoint Server 2007 RTM

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

Warning

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

Install PerformancePoint Server 2007 SP3

PerformancePoint Planning Server SP3 updates the PerformancePoint Planning Server Configuration Manager. The Planning Server Configuration Manager is run after SP3 has been installed. To install PerformancePoint Planning 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.