Enable backwards compatibility mode on a fresh Project Server 2010 install

One of the great features of Project Server 2010 is Backwards Compatibility Mode (BCM). With BCM, users can connect to Project Server 2010 with both Project Professional 2007 and 2010 clients. This can be a great bonus for companies that have already standardised on the Project 2007 toolset but want the features of Project Server 2010 without a costly client upgrade and rollout.

Typically BCM is turned on when you upgrade your existing Project Server 2007 environment to Project Server 2010. If you do a fresh install of Project Server 2010, the server is installed in Native 2010 mode, only allowing Project 2010 clients to attach. However, it is possible to do a fresh 2010 install and enable backwards compatibility mode, and here’s how…

1. Create a set of Project Server 2007 databases by provisioning a new Project Server PWA instance.

Fresh Provision

2. Save the four ‘clean’ databases created in your Project Server 2007 environment and back them up via SQL Server Management Studio. Restore the four ‘clean’ databases into your Project Server 2010 environment database and make sure they have the correct permissions for your environment (more info on restoring databases and setting the permissions can be found here)

Restore DB

3. In the 2010 environment, provision a new Project Web Application instance via Central Admin > Manage Service Applications > Project Server Service Application. In the configuration screen, change the four default database names to reflect the ‘clean’ Project Server 2007 databases restored above.

Central Admin - new SA 1

Central Admin - new SA 2

4. Confirm that backwards compatibility mode has been turned on for the PWA instance in Server Settings > Additional Settings

Additional Server Settings - BCM

There you have it, the server now supports both Project Professional 2010 and Project Professional 2007.

Update: Microsoft have released a set of clean Project Server 2007 databases that can be used to create a fresh 2010 instance. More details here.

6 thoughts on “Enable backwards compatibility mode on a fresh Project Server 2010 install

  1. Pingback: Backwards Compatibility Mode–Project Server 2007 Fresh Databases available from Microsoft Download Center « EPMSource

  2. I found it was necessary to make one of the following changes (not sure which, since I made both prior to reattempting):
    – Edit the owner of the four DBs on the “Files” page of the DB properties dialog and set it to the farm admin service account. e.g. domain\FarmAdminServiceAccount
    – On the Options page I set the “Compatibility Level” to “SQL Server 2008 (100)” from “SQL Server 2005 (90)”.

    Prior to making these changes I was getting: “Failed – see the Application event Log”
    I didn’t find anything useful (i.e. no error messages) in the log, BTW.

  3. I am a MAC user but my boss is running Windows 7 and recently upgraded to MS Project 2010 here at work.
    Unfortunately IT here is unable to determine why she is having issues with automatic scheduling updates.

    Every time she opens an old MS timeline that perhaps was done in 2007, she is unable to update her dates automatically and must enter them manually. Can anyone help me fix this issue? It can’t be that her system is in compatibility mode because it does not say it anywhere on the screen. Anyone has any suggestions?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s