How to configure Project Server 2007 Cube Building Service with SQL Server 2008 Analysis Services

A lot of you have been asking for it, the TechNet team just published it :)

Requirements for using SQL Server 2008 Analysis Services with the Project Server 2007 Cube Building Service

and yes Project Server 2007 is supported on SQL Server 2008 as stated here (bottom of the page):

Office Project Server 2007 supports Microsoft SQL Server 2008. However, you must install Windows SharePoint Services 3.0 with Service Pack 1 (SP1) or later as well as Office Project Server 2007 SP1 or later before you install SQL Server 2008.

ScreenHunter_06 Nov. 21 07.18



Key reasons why consider SQL 2008:

  • Performance, by implementing database backup compression.
  • Availability, by implementing log stream compression.
  • Security, by implementing Transparent Data Encryption (TDE).
  • Resource management, by using SQL Server 2008 Resource Governor
  • Reporting Services 2008 (much easier to author custom reports and rich rendering using the acquired Dundas control)
  • Analysis Services 2008

Check the related TechNet article for more information: