How to upgrade your existing Microsoft Project VPC running on SQL 2005 to SQL Server 2008

I’m sure you have seen these cool SQL Reporting Services 2008 reports: Microsoft SQL Server Reporting Services 2008 – Sample Project Server Reports and would like to do the same in your favorite EPM demo VPC or you just have plenty of free time during this time of the year and you are looking for a fun project, hence please find below the steps to upgrade an existing image running on SQL 2005 to SQL 2007 (should take about two hours depending on hardware):

Download SQL Server 2008 Developer (x86, x64, ia64) - DVD (English) using your MSDN Subscription. Start your favorite EPM image using your favorite virtualization production Hyper-V and mount the ISO downloaded. image

SQL Server 2008 Setup requires two updates prior to install:

  • .NET Framework 3.5 SP1
  • Windows Installer 4.5
ScreenHunter_11 Dec. 16 09.18
.NET Framework 3.5 SP1 Setup ScreenHunter_13 Dec. 16 09.22
One pre-requisite is to have the latest version of Windows Installer 4.5 ( KB942288-v4 ); install and reboot image
Start Upgrade Wizard image
Setup Support Rule are run successfully image
Choose the Instance to Upgrade image
All Upgrade Rules are passed successfully, start upgrade process (it took about 90min on Dell Precision 690) image
Upgrade Progress finished successfully image

Download and install the following components from the Feature Pack for Microsoft SQL Server 2005 - December 2008 (all X86 Package in this case):

  • Microsoft SQL Server Native Client (sqlncli.msi)
  • Microsoft SQL Server 2005 Management Objects Collection (SQLServer2005_XMO.msi)
  • Microsoft SQL Server 2005 Backward Compatibility Components (SQLServer2005_BC.msi)

These components are required to properly configure the Cube Building process.

Rebuilt your cube and voila!  

Related Links