Howard @ MSFT selling BI

Just another WordPress.com site

PPS and 2008 SQL and Windows Server

I am building out a PURE 2008 hyper-v environment for an upcoming POC. PPS doesn’t officially support SQL Server 2008 until SP2 due out in the beginning of Dec 2008. There is a beta PPS SP2 now available.

I want to use SQL 2008 as for my PPSMonitoring repository DB, and connect to SQL 2008 cubes. There are some SQL 2005 redistributables that are required and available here

  • Sqlncli
  • SQLServer2005_ADOMD
  • SQLServer2005_ASOLEDB9
  • SQLServer2005_XMO

Once installed they must be upgraded to at least CU7 of SQL Server 2005. The CU7 versions of those components are REQUIRED in order for PPS to talk to SQL 2008. That is the bridge-point version where SQL 2005 is able to talk to SQL 2008. These redists must be installed on all PPS machines. Contact support for these updated redists. CU7 is documented here.

Install RTM Version of PPS (version=3520). Do not run the configuration manager.

Install SP2 version of PPS. Run Configuration manager. I am running only SP2 beta M&A and my Dashboard Designer version is 3.0.4208.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.