The integration for Team Foundation Server and Project Server is not configured correctly

The information in this article applies to:

• Visual Studio Team Foundation Server 2010 with Service Pack 1

• Windows Server 2003 and Windows Server 2008

• Team Foundation Server and Project Server Integration

• Team Foundation Server Complete Health Check

• Project Server Configuration Health Check

• Project Server Synchronization Health Check

The Best Practices Analyzer tool for Team Foundation Server performs a number of checks to determine if prerequisite software has been installed and permissions assigned to support the integration of Team Foundation Server and Project Server.

• If prerequisite software has not been installed, one or more of the following error messages appears:

  • Version requirements are insufficient to support Team Foundation Server and Project Server Integration.

  • Service level requirements are insufficient to support Team Foundation Server and Project Server Integration.

  • Missing the feature pack for Team Foundation Server and Project Server Integration.

  The text of the error message indicates which software component is missing. For deployments that are based on Project Server 2007, see the Microsoft website: Description of the Office Project 2007 hotfix package: February 23, 2010. To resolve other messages and to gain access to the required software, see System and Setup Requirements to Support Integration of Team Foundation Server and Project Server.

• If required permissions have not been granted to service accounts to access SQL Server, one or more of the following error messages appears:

  • The service account for the web application pool for Project Server has insufficient permissions to update the publishing databases for Project Server.

  • The service account for the web application pool for Project Server has insufficient permissions to update the reporting databases for Project Server.

  • The service account for the Project Server Event Handler has insufficient permissions.

  • Service account for the application pool for Project Web App does not have sufficient permissions to support Team Foundation Server and Project Server Integration.

  Insufficient permissions can interfere with your ability to integrate Team Foundation Server and Project Server. You must resolve these errors to support configuration and data synchronization.

  You must grant permissions to the service account for the web application pool to update two SQL Server databases for Project Server 2010. To update the Publishing database, the service account must have the Select permission. To update the Reporting database, the service account must have the Alter any Schema, Create Table, Delete, Execute, Insert, Select, and Update permissions. Also, the service account for the Project Server Event Handler must have Full Control permissions to the Project Server Service Application.

  For more information, see Assigning Permissions to Support Integration of Project Server and Team Foundation Server.

• If the required permissions have not been granted to service accounts to configure the integration or participate in data synchronization, one or more of the following error messages appears:

  • Service account for Team Foundation Server does not have sufficient permissions to support Team Foundation Server and Project Server Integration.

  • Service account for the application pool for Project Web App does not have sufficient permissions to support Team Foundation Server and Project Server Integration.

    You must resolve these errors to support configuration and data synchronization. For more information, see Assigning Permissions to Support Integration of Project Server and Team Foundation Server.

• If the user running the Best Practices Analyzer tool does not have sufficient administrator permissions to configure the integration of the two server products, the following warning message appears:

  • User running BPA has insufficient permissions to configure Team Foundation Server and Project Server Integration.

    To resolve this message, grant administrator permissions to the user account that runs the BPA tool. You must add the user to the Team Foundation Administrators group and to the Administrators group for each instance of PWA that you will register with Team Foundation Server.

See Also

Other Resources

Issues That Relate to the Application Tier for Team Foundation