Add a Report Server to Your Deployment

  • Article

Project managers and other team members can use reports to track progress if you add a server that is running SQL Server Reporting Services to your installation of Visual Studio Team Foundation Server. You can add a report server to a standard or an advanced installation, but you cannot add a report server to a basic installation. If you add a report server, project members can also customize reports to better meet their specific needs. You can add a report server when you install Team Foundation Server or at any time after the initial installation process has been completed.

Note

You cannot add reports automatically to existing team projects and team project collections simply by adding a report server to a deployment. All team project collections that you create after you add a report server will have reporting capabilities, as will all team projects that are created in those collections. If you want to add reporting to existing collections and projects, you must perform additional steps. For more information, see Add a Report Server to a Team Project Collection and Add Reports to a Team Project.

Each deployment of Team Foundation Server can include only one report server. All reports that in that deployment will be processed and stored on that server. If your deployment of Team Foundation Server also uses SharePoint Products, reports and dashboards in SharePoint Products will rely on this report server.

Required Permissions

To perform these procedures, you must be a member of the following groups:

  • The Team Foundation Administrators group, or your Edit instance-level information permission must be set to Allow.

  • The Content Managers group or the TFS Content Managers group in SQL Server Reporting Services.

  • Before you can create a report folder as part of adding a report server, the service account that the Visual Studio Team Foundation Background Job Agent (TFSService) uses must have certain permissions. For more information, see Service Accounts and Dependencies in Team Foundation Server and Team Foundation Background Job Agent.

For more information about permissions, see Team Foundation Server Permissions.

To add a report server to a deployment of Team Foundation Server

  1. Open the administration console for Team Foundation.

    For more information, see Open the Team Foundation Administration Console.

  2. Under Team Foundation, expand the name of the server, expand Application Tier, and then click Reporting.

  3. In Reporting, click Edit.

    The Reporting Services dialog box opens.

  4. On the Warehouse tab, provide the following information:

    1. In Server, click or type the name of the server that hosts the warehouse database for Team Foundation Server.

    2. If you want to use an instance that is not the default instance, select the Specify non-default instance check box, and then type or click the name of the instance that you want to use.

    3. In Database, type the name of the warehouse database.

      By default, the name of this database is Tfs_Warehouse.

    4. (Optional) Click Test Connection to verify that all the information that you have provided is correct and that the database that you specified has a valid schema.

  5. On the Analysis Services tab, provide the following information:

    1. In Server, click or type the name of the server that hosts the analysis database for Team Foundation Server.

    2. If you want to use an instance that is not the default instance, select the Specify non-default instance check box, and then type or click the name of the instance that you want to use.

    3. In Database, type the name of the database.

      By default, the name of this database is Tfs_Analysis.

    4. (Optional) Click Test Connection to verify that all the information that you have provided is correct and that the database that you specified has a valid schema.

    5. In Account for accessing data sources, type the data sources account (referred to by the placeholder TFSReports) in Username, and type the password for that account in Password.

  6. On the Reports tab, select the Use Report Server check box.

    1. In Server, click or type the name of the report server.

    2. Click Populate URLs to automatically populate the URLs for the Web service that the report server uses and the URL for Report Manager.

      As an alternative, you can click or type each of these values.

    3. In Account for accessing data sources, type the name of the TFSReports account in Username, and type the password for that account in Password.

    4. In Team Foundation Server Reports, type the path for reports in Default Path.

      By default, the value of this field is /TfsReports.

  7. Click OK.

  8. In Reporting, click Start Jobs to start the processing of the warehouse and Analysis Services jobs.

See Also

Tasks

Add a Report Server to a Team Project Collection

Add Reports to a Team Project

Create a Team Project Collection

Concepts

SQL Server and Team Foundation Server

Planning and Tracking Projects

Updating an Upgraded Team Project to Access New Features

Other Resources

SharePoint Products and Team Foundation Server

Change History

Date

History

Reason

March 2011

Clarified the limitation for basic installations of Team Foundation Server.

Customer feedback.