Project Server 2007 SP1 supports SQL Server 2008

  1. From https://technet.microsoft.com/en-us/library/cc197379.aspx
    1. '...Note: 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...'
  2. An OLAP gotcha from Brian
    1. https://blogs.msdn.com/brismith/archive/2008/10/27/project-server-2007-and-sql-server-2008-error-messages-with-data-analysis-cubes-olap.aspx