Project Server 2007 & Project 2007 – Some Technical ‘Need to Knows’

• Project Standard 2007 can’t connect to Project Server.
• Only Project Professional 2007 can connect to Project Server 2007.
• Project Professional 2007 is not compatible with Project Professional 2003 or earlier versions.
• Project Server 2007 approval workflows require MOSS to function. 

Basic Project Server 2007 install includes:

• Windows Server
• SQL Server
• SQL Analysis Server
• WSS (Windows SharePoint Services)
• IIS (Internet Information Services)
• .NET Framework.

Great competitive advantage is the expanse of the Microsoft Office platform and the SharePoint collaborative platform. There are a huge range of solutions here to leverage from.

There are 2 primary installation types for Project Server 2007:

• Stand alone – This installation type provides limited functionality and scalability, however it installs onto a single server using default settings and SQL Server express 2005. It does not activate all enterprise capabilities and it does not support analysis services.
• Server Farm – This installation type requires full version of SQL Server 2005, specifically dependant on Microsoft database technologies.

Microsoft does not recommend a single-box deployment. In fact, aim for separation between the application and database environments for better stability and maintenance. 4 servers, load balanced with failover capability will result in a high-availability environment, this is the recommended setup.

Project Server 2007 has 4 databases used to represent and manage project data (instead of 1 previously), these are:

• Draft – where all plans and change to plans are saved until the PM explicitly publishes the project. Information here is not viewable in PWA.
• Published – viewable in PWA contains enterprise resources, global records, global templates, security and timesheet information.
• Archive – Backup plans and other backed up objects.
• Reporting – written to on publish of project data. De-normalised for ease of data mining. Near-real time information provided for reports. 

There are also 2 WSS Databases:

• WSS Configuration – this is required for Project Server 2007 and defines the WSS Farm.
• WSS Content – Holds all SharePoint content for Project Server 2007.