Official communication regarding Project Server 2007 and SQL Server 2008
Taken from Christophe Fiessinger's offical communication regarding this topic:
Microsoft Project Server 2007 supports Microsoft SQL Server 2008 (released last august).
You’ll find below related links including how to configuration the Cube Building Service.
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)
Check the related TechNet article for more information:
· Determine hardware and software requirements (Project Server)
Check the note at the bottom of the article:
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.
This article describes requirements for using SQL Server 2008 Analysis Services with the Microsoft Office Project Server 2007 Cube Building Service.
· Integration of SQL Server 2008 and Office SharePoint Server 2007
This article provides prescriptive guidance for implementing some of the new features in Microsoft SQL Server 2008 that enhance the deployment of Microsoft Office SharePoint Server.