Project Server 2007 – Common installation problems

These are probably repeats for many of you reading – but based on personal experience there are still some people that haven’t got these messages:-

  1. If you are going to run Microsoft Office SharePoint Server 2007 and Microsoft Office Project Server 2007 on the same farm then ALL servers need both sets of bits loaded – and preferably Office SharePoint Server loaded first.  Failure to do this will probably first be seen when provisioning fails for your PWA sites.  You don’t have to run all the services on all the servers – but you just can’t have a “Project Server” in a farm of SharePoint servers.
  2. If you do a one-click installation of Microsoft Office Project Server 2007 (either using the Basic option, or then Advanced and Stand-alone) and then can’t find your databases then chances are they are in a SQL Server 2005 instance called <machinename>OFFICESERVERS.  The one-click doesn’t allow you to choose your database server – it creates a SQL Server 2005 Express Edition instance for you.  If this isn’t what you want then best to uninstall and try again – this time using the Advanced, and then Complete – which does allow you to select your SQL Server.  This will still permit you to have everything on a single stand-alone server – but with the SQL Server of your choice.

Technorati Tags: Project Server 2007