Add a Report Server to a Team Project Collection
If you add a report server to a collection, project members can use default reports to track progress on team projects in that collection. Project members can also customize reports to better meet their specific needs. By default, support for reporting is added to a collection when it is created if a server that is running SQL Server Reporting Services was configured as a report server for your deployment of Team Foundation Server (TFS). However, you might not have had a report server configured for your deployment when you created the collection, or you might have overridden the default settings and not configured reporting for the collection. In either case, you can add support for reporting to a collection at any time after a report server has been added to the deployment.
You cannot automatically add reports and reporting capabilities to the projects that already exist in that collection simply by adding a report server to a collection. All team projects that you create after you add a report server will have reporting capabilities, but any team projects that already exist in that collection will not have reporting.
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.
To create a report folder as part of adding a report server to a collection, 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
Open the administration console for Team Foundation.
For more information, see Open the Team Foundation Administration Console.
Expand the name of the server, expand Application Tier, and then choose Team Project Collections.
In Team Project Collections, highlight the collection to which you want to add reporting, and then choose the Reports Folder tab.
On the Reports Folder tab, choose Edit Default Folder Location.
The Edit Default Folder Location window opens.
In Folder path on the Reporting Services Server, specify the relative path and folder name for reports for this collection, and then choose OK. For example, if the relative path is "tfsreports" and the collection name is "Contoso1", you would type /tfsreports/Contoso1.
If your user account has the appropriate permissions, you do not have to create this folder beforehand. It will be created for you. If the service account does not have the permissions that are required to create a folder in the path, you must specify a folder in that path that has been created for this purpose.
If a warning appears advising that no such folder exists, verify that you have specified the correct folder name and relative path. If you want to create a folder in that location, choose OK. If you must change the name or the path, choose Cancel.