Martyn Bullerwell's blog

January 2008 - Posts

PerformancePoint and Windows Server 2008

Well, the testing has continued this week after having issues with SQL 2008 with PerformancePoint, I rebuilt one of our test servers with the Latest Server CTP.  Obviously as I am keen to always know what Microsoft are up to in as many areas as possible, so I thought it wise to install Server 2008 with Hyper-V.  Now this seems like a great idea, however, it seems that this particular version is only available as a 64Bit variant at the moment, and they do not make that all to clear while installing.  So after installing this, and SQL server 2005, as to test PerfomancePoint on Server 2008, it seems that the version check for Windows fails, with is not ideal.  This seems to be solely due to the fact that it is a 64 Bit version. 

So, the next step is to try the Install with the NoReqCheck option ( post on this can be found here ), now this does actually get PPS Server to install, however the configuration will not run.  I have not tested the 64 bit version of PPS on Server 2008, as it seems that Pro Clarity 6.3 is ONLY 32 bit. PPS 2007 currently doesn't offer the Analytics Component that Pro Clarity 6.3 offers. I'm sure, however this will be released in the next version of PPS 2007.

PerformancePoint Server and SQL 2008

So after many hours looking into this issue, it seems that the current release of PPS does not work on SQL Server 2008, and there seems to be no tricking it.  Should you manage to get round the install checks, while setting up the Database Connections to SQL and Analysis servers, the versions are checked once again, and the door is currently closed.

In the mean time, SQL 2005 will still work!  SQL 2008 is still due to Launch SQL 2008 in February, however it now looks as if the RTM (Release to Manufacture) will now not be until Q3 of 2008 - so we are unlikely to see,even early adoption

until July time.  Microsoft see  SQL server 2008 as a critical step forward towards their "broader vision for business intelligence", so I think we can be rest assured that PerformancePoint will be integrated before release date. 

In the mean time I will update you with any further developments on this, and will continue testing with further CTP's and patches.