How to: Add the Service Account for Team Foundation Server to the Report Server
If SQL Server Reporting Services and Visual Studio Team Foundation Server are not on the same server, you must add the name of the service account that you will use for Team Foundation Server (TFSSERVICE) to the Content Manager group on the report server. This step is done automatically during Team Foundation Server setup, if the report server is installed on Team Foundation Server.
If you are using Network Service for TFSSERVICE, you must add the machine name of the server that is running Team Foundation Server instead of Network Service. The machine name is the server name followed by the $ symbol (for example, Domain\ServerName$).
For more information about service accounts, see Accounts Required for Installation of Team Foundation Components.
To perform this procedure, you must be a member of the Administrators security group on the report server.
To add the service account for Team Foundation Server to the Content Manager group on the report server
On the server that is running SQL Server Reporting Services, click Start, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and click Reporting Services Configuration Manager.
On Windows Server 2008, you must right-click Reporting Services Configuration Manager and click Run as administrator.
The Reporting Services Configuration Connection dialog box appears.
In Server Name, type the name of the report server. If you are using an instance name, click the name of the instance in the Report Server Instance list. Click Connect.
Click Report Manager URL, and click the link to the report manager Web site.
The report manager Web site for the report server opens in an Internet browser window.
In the report manager Web site, click the Properties tab, and then click New Role Assignment.
In Group or user name, type the name of the service account that you will use for Team Foundation Server (TFSSERVICE), select the Content Manager check box and then click OK.