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.
SQL Server 2008 Setup requires two updates prior to install: .NET Framework 3.5 SP1 Windows Installer 4.5
.NET Framework 3.5 SP1 Setup
One pre-requisite is to have the latest version of Windows Installer 4.5 (KB942288-v4); install and reboot
Start Upgrade Wizard
Setup Support Rule are run successfully
Choose the Instance to Upgrade
All Upgrade Rules are passed successfully, start upgrade process (it took about 90min on Dell Precision 690)
Upgrade Progress finished successfully
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 Microsoft SQL Server 2008 Upgrade Technical Reference Guide is Live! How to configure Project Server 2007 Cube Building Service with SQL Server 2008 Analysis Services Upgrading SharePoint SQL Servers to SQL Server 2008 Microsoft SQL Server Reporting Services 2008 – Sample Project Server Reports

No results found