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.
Like this:
Be the first to like this post.