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:
Install SQL Server 2005 Service Pack 3 (SP3) software on all computers hosting PerformancePoint Planning Server components
Install SQL Server 2008
Install PerformancePoint Planning Server 2007 RTM
Important
Do not configure PerformancePoint Planning Server until after SP3 has been installed.
Install PerformancePoint Planning Server SP3
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
Browse to Feature Pack for Microsoft SQL Server 2005 - December 2008.
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
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.
Proceed through the installation wizard, accepting all default options.
When the installation wizard finishes, click Finish to exit.
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
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).
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.
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.