Cascade Skyline - with Microsoft Logo and Project Support header - author Brian Smith

Project Server 2007 - Common installation problems

Project Server 2007 - Common installation problems

Rate This

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

Leave a Comment
  • Please add 1 and 5 and type the answer here:
  • Post
  • Brian,

    Just thought I'd let you know, it looks like it may be an Active Directory issue of some sort.  When our dba connects first, it works fine for him and it also starts to work for me.  The next day it breaks again.

    That would seem to indicate that some permission is getting set and cached when he logs in but expires over night and I don't have the rights to set it.

    I'll let you know if we find the exact error.

    Thanks for your help.


  • Brian

    I have setup Project Web Access with SQL Forms Based Authentication.

    I have created the sites with host headers using SSL which I can access from a Web Browser no problems.

    However I am running into trouble importing a user using the PJFormsAuthUpgrade tool.

    The command I am using is:

    PJFormsAuthUpgrade -usersfile users.xml -url https://<hostheader>/pwa

    It returns the following message:

    You have specified a Project Web Access site which requires Forms Authentication. In order to access this site you need to specify a Forms Authentication Username and Password.

    Any help would be greatly appreciated.


  • Hi ecrhone,

    The SQL option should work - and you don't say what issues you are having.  personally I find that using ADAM is more flexible and will work in the single server environment.  Take a look at for a couple of postings about using LDAP.


  • Hi Aaron,

    One common mistake with FormsAuthUpgrade is not adding the membership provider section to the port 80/443 web.config.  Even though you probably use Windows auth on port 80/443 formsauthupgrade needs to get the membership provider from the port 80 web.config to work.

    Is this you problem?


  • I had installed a PS2007 Server and Pro 2007 on a client machine. Cannot connect Pro to Server. Its leaves a Login failed message. PWA has been provisioned. But not able to access PWA through browser. "An Unexpected Error Occured" is the message---Pls Help... THanks in advance....

  • Hi Ajith,

    I'm not sure what the problem might be, but the ULS logs should give some indication.  You can also turn on more meaningful errors by modifying the web.config for the site. give some excellent instructions for doing this.


  • Hi

    Installed our Sharepoint 2007 and then Project Server using the using the one click installation option, the guys over here have been using the system now for more than a year already, with a bunch of project / documents / images...

    Now they've relized that it's running using SQL Express, and would like to move it to SQL 2005 Standard Edition is this possible and how can it be done?

  • Hi Mvanwyk,

    Probably the easiest way would be to take a full farm backup, and then re-install using the custom option where you can select your SQL Server.  Once you are back to a point where you have SharePoint and Porject installed - but not configured (just to the point of having Central Administration up and running) then you can do a full farm restore and change the database server name as you restore (also a good time to shorten the database names if you want.  Take a good look at the documentation for full farm backup/restore - and I would also suggest doing this with SP1 installed.

    Best regards,


  • Janet,

    It looks like we're having the same issue that you were.  Did you ever find a resolution?


  • Heya, Brian.

    I wonder if anyone has had this one:

    SharePoint runs fine (port 80). Central Administration lists 2 sites under Manage Project Web Access Sites (/pwa and :33250/pwa).  I cannot add a Project to either one.  I get a dialog box saying project cannot open the file and to check the file type and path.  The only odd thing I can put a finger on is the fact that the Project Server is the trial version.

    BTW, thanks for the BLOG.

  • No sure what's happening here.  What port is your SSP using?  Is PWA working OK?

  • Since I installed MS project 2007 on our webserver most of our sites are no longer accessible.(see error)

    Object reference not set to an instance of an object.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:

    [NullReferenceException: Object reference not set to an instance of an object.]

      Microsoft.SharePoint.Utilities.SPUtility.AlternateServerUrlFromHttpRequestUrl(Uri url) +28

      Microsoft.SharePoint.Administration.SPAlternateUrl.get_ContextUri() +134

      Microsoft.SharePoint.WebControls.SPControl.GetContextWebApplication(HttpContext context) +131

      Microsoft.Office.Server.ServerContext.GetContext(HttpContext httpContext) +93

      Microsoft.Office.Server.ServerContext.get_Current() +29

      Microsoft.Office.Project.PWA.PJLanguageManager.SetBestUICulture() +88

      Microsoft.Office.Project.PWA.PwaAuthenticationModule.Application_PreRequestExecuteAppHandler(Object oSender, EventArgs ea) +134

      System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92

      System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

    If I uninstall the ms project server then I get a 404 for our existing sites.

    Any help woul;d be appreciated.


  • Hi Jesse,

    What were your existing sites? You do not say what you installed Project Server 2007 on - apart from a webserver.  If you did a default install then possible port 80 is now "owned" by WSS 3.0 so this could be the issue.  After removing Project Server 2007 it is possible that the web site for port 80 is no longer active.

    Best regards,


  • CP,

    We still have not fixed the problem.  It is definitely a permissions issue.  If I use an account that has local admin on the server when I access a site, then everyone else can get to the pages without a problem for about 24 hours.

    We're going to go through the permissions with our AD person this week and if he can't figure it out we'll be submitting a support request.


  • Is there any chance you could send me the file PjFormsAuthUpgrade.exe. I am an developer and I would like to import users into the SQL Membership Database but I do not have Project Server. Here is my email,



Page 5 of 10 (148 items) «34567»