PPS SP2 and SQL 2008 revisited - Windows Live

How to install SQL 2008 with PerformancePoint.

After 2 days I finally figured out why the pps olap charts and grids would not work in my pure 2008 environment. Also proclarity.  You must install the SQL 2005 CU9 redists BEFORE installing SQL Server 2008. Here is the order of operations

• Install Windows Server 2008
  • add IIS and AppServer roles (incl. CGI, ASP, IIS6 mgmt)
• Install the 4 SQL 2005 CU9 redists
  • Sqlncli
  • SQLServer2005_ADOMD
  • SQLServer2005_ASOLEDB9
  • SQLServer2005_XMO
• Install SQL Server 2008
  • DB (incl. full text search for AdWorks sample), AS, RS
• Install MOSS 2007 SP1
  • Create SSP, site collection
• Install PPS 2007 RTM
  • do NOT run config mgr
  • install PPS SP2
    • run Config mgr
• Install PAS/Desktop
  • install SP2
• Install Visio, Office, etc

PPS SP2 and SQL 2008 revisited - Windows Live