Things to keep in mind when configuring Team Foundation Server and Project Server Integration Beta

    General discussion

  • Folks,

    As people install and configure the Team Foundation Server and Project Server integration, we'll be updating this thread with key items to keep in mind.

    (1) MUST DO ITEM FOR Setup and Configuration -- Read the documentation

    Please read and follow the documentation!  You can get the documentation online. Or you can download the .CHM file. (Please note that after you download the file you'll need to Right-Click, Select properties and click Unblock to view the content).

    (2) MUST DO ITEM FOR Project Server 2010 -- Modify PWA web.config

    This is a post-install step after installing Team Foundation Server SP1 and the Team Foundation Server and Project Server Feature Pack on Project Server. 

    Locate the web.config for the IIS SharePoint 2010 web site hosting the Project web application
    Edit the web.config file using Visual Studio or notepad.
    Search for the <assemblyBinding> section of the XML.
    Add the follow in the <assemblyBinding> section:
    <dependentAssembly xmlns="urn:schemas-microsoft-com:asm.v1"><assemblyIdentity name="Microsoft.Office.Project.Server.Library" publicKeyToken="71e9bce111e9429c" culture="neutral"/><bindingRedirect oldVersion="" newVersion="" /></dependentAssembly>
    Save the file.

    (3) MUST DO ITEM FOR Project Server 2010 -- Giving the service account for TFS the right permissions

    In the documentation, there is a topic called: Configuring the integration of Team Foundation Server and Project Server.  In that topic, there is a section called Grant Permissions and a note that states that for Project Server 2010, the service account for Team Foundation Server needs Full Control permissions to start the Project Server Service Application.  The detailed steps on how to do this are defined in the Configuration Quick Reference topic and copied below:

    To add a service account to a service application by using SharePoint Central Administration (2010)

    1. Open the SharePoint Central Administration page for Project Server.

    2. Under Application Management, click Manage service applications.

    3. On the Manage Service Applications page, click Project Server Service Application.

      The ribbon becomes available.

    4. In the ribbon, click Permissions.

    5. In the Connection Permissions for Project Server Service Application dialog box, type the name of the service account, and then click Add.

    6. In the middle pane, make sure that the name of the service account that you just added is highlighted.

    7. In the bottom pane, select the Full Control check box, and then click OK

    (4) MUST DO ITEM: If you have not given the Service Account for the Web Application any permissions

    OR if you see the following error when trying to Register the PWA

    TF244069: An error occurred while checking the provisioning status of the reporting database scheme for a PWA instance.

    Project Server returned the following error: "TF289004: An error occurred while communicating with Project Server. Contact your Project Server administrator.".

    You will need to set the permissions for the account used by the application pool for the web application that hosts Project Server at the Reporting Database. Please set it as db_owner for the Project Server Reporting Database.

    In addition, the service account of the application pool of the web application hosting the PWA site  needs "select" permission granted on PWA Published DataBase.

    (5) MUST DO ITEM if your Team Foundation Server has a "." (a period) in its URL.  E.G: http://my.tfs.server.com

    This is a bug that is for RTM.  For the Beta, the following workaround is required:

    On the machine where you are running the registerPWA command:

    o   Use notepad to open the “hosts” located at %systemroot%\system32\drivers\etc or %systemroot%\systemWOW64\drivers\etc.

    §  At the end of the file add an entry mapping the IP address of your TFS Server to a new friendly name that you can pick for the server. Make sure that the friendly name you specify does not include a period “.”.

    §  Save and close the file.

    o   To confirm that your friendly name is working, you can open Visual Studio and connect to your TFS server using the friendly name.

    o   Run the TfsAdmin projectserver /registerPWA command again but this time using the friendly name in your TFS URL instead of your original host name. The command should succeed.

    o   Open IE and navigate to your PWA web site.

    §  Click Server Settings-Enterprise Custom Fields and Lookup Tables (on 2010)

    §  Click Server Settings-Enterprise Data (on 2007)

    §  Click Microsoft.VSTS.ProjSrv.TFSMapLT.DoNotDelete (Under Lookup Tables for Custom Fields)

    §  In the Code Mask: change the separator from “.” to “\”

    §  In the Lookup Table: change the Value column of the first line and replace  the URL you see there (which contains the friendly name)  by the original  URL.

    §  Save your changes.

    o   You should now be able to run the remaining of the tfsadmin provisioning commands using the original TFS URL.



    (6) MUST DO ITEM If you have all the components (Project Professional 2010, Visual Studio 2010, Team Foundation 2010 and Project Server 2010) installed in the same machine you need to create the files below and copy them on the same folder their correspondent .exe file exists. Note that this is only need if you are using Project Server 2010.


    Create file tfsadmin.exe.config with the following content


    <?xml version="1.0" encoding="UTF-8" ?>



            <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">

                <probing privatePath="PrivateAssemblies" />


                    <assemblyIdentity name="Microsoft.Office.Project.Server.Library" publicKeyToken="71e9bce111e9429c" culture="neutral" />

                    <bindingRedirect oldVersion="" newVersion="" />







    Create file winproj.exe.config with the following  content



    <?xml version="1.0" encoding="UTF-8" ?>



            <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">


                    <assemblyIdentity name="Microsoft.Office.Project.Server.Library" publicKeyToken="71e9bce111e9429c" culture="neutral" />

                    <bindingRedirect oldVersion="" newVersion="" />





    Wednesday, December 08, 2010 4:22 AM

All replies

  • We are trying to integrate Project Server 2007 with TFS 2010. Do I have to make the same edits to PWA's web.config  ?
    Tuesday, December 14, 2010 6:12 PM
  • Hi Nachal,

    No, you don't have to make the same edits to the web.config for Project Server 2007.  This is a step only for Project Server 2010.



    Tuesday, December 14, 2010 8:35 PM
  • Hi,


    I've a erreor after changes (Step 2) ans 'Step 3), I can't Map to collection :

    C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE>TfsAdmin Project
    Server /MapPWAToCollection /pwa:http://ps2010/PWALAB /Collection:http://ps2010:8

    Mapping team project collection http://ps2010:8080/tfs/Collection_One/ to PWA ht

    ......The request failed with HTTP status 401: Unauthorized.

    C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE>

    Thank you

    mon blog : http://choulant.blogspot.com
    Wednesday, January 05, 2011 11:40 PM
  • Hi,

    Can you confirm that the service account for TFS has the right permissions to access the PWA?

    See here for the details: http://msdn.microsoft.com/en-us/library/gg412653.aspx




    Thursday, January 06, 2011 1:24 AM
  • Hi,

    Sorry, I forget this permission. Thank you

    mon blog : http://choulant.blogspot.com
    Thursday, January 06, 2011 6:41 AM
  • hi,

    I have register successfully PWA site. but facing problem with map team collection site.

    which is like this

    The request failed with HTTP status 401: Unauthorized.


    Wednesday, March 09, 2011 12:45 PM
  • Hi Pankaj, can you please verify that the TFS service account is part of the Administrators group in the PWA that you are trying to map to your collection.
    Thursday, March 10, 2011 5:16 PM
  • Hi federico,

    Yes TFS Service account is the part of Administrator Group, and all permissions have already appled according to Document which is available online.



    Friday, March 11, 2011 8:51 AM
  • The link of the .chm seems to be broken.


    Friday, March 02, 2012 1:26 PM
  • Thanks for noticing that Daniel. The updated link is this http://go.microsoft.com/fwlink/?LinkID=210709.

    Federico Kolliker Frers - MSFT

    Monday, March 05, 2012 5:31 PM