SQL Server Reporting Services is not configured correctly
The information in this article applies to:
Visual Studio Team Foundation Server 2010
Windows Server 2003 and Windows Server 2008
SQL Server 2008
Server that hosts SQL Server Reporting Services
Team Foundation Server Complete Health check
Team Foundation Server Framework Health Check
Team Foundation Server Warehouse Health Check
The Best Practices Analyzer tool for Team Foundation Server performs several configuration checks on SQL Server Reporting Services. The tool logs the information that it gathers in the tree report under the Data Source Verification node**.** You can locate this node by expanding Team Foundation Server Complete Health Check, expanding Reporting Servers, and then expanding the URL for Report Manager.
An error appears if any of the following conditions occur:
Reporting Services data source (Tfs2010OlapReportDS) cannot be found
Reporting Services data source (Tfs2010ReportDS) cannot be found
The Tfs2010OlapReportDS data source is not enabled
The Tfs2010ReportDS data source is not enabled
To resolve access to the reports that are built from data in the data sources, you must verify that the data sources are enabled and correctly configured with valid credentials.
Hinweis
If you upgraded to Team Foundation Server 2010, there are two sets of data warehouse resources. The names that are assigned to resources for Team Foundation Server 2010 are Tfs2010ReportsDS and Tfs2010ReportsDS. For more information about other data warehouse resources, see the following page on the Microsoft Web site: Locating Reports After the Upgrade to Team Foundation Server 2010.
Required Permissions
To perform these procedures, you must be a member of the following groups:
The Administrators group on the server that hosts SQL Server Reporting Services.
The Team Foundation Content Manager group in SQL Server Reporting Services.
In addition to these permissions, you might need to address the following requirements on a computer that is running Windows Server 2008 or Windows Vista:
To follow a command-line procedure, you might need to open an elevated Command Prompt by clicking Start, right-clicking Command Prompt, and clicking Run as Administrator.
To follow a procedure that requires Internet Explorer, you might need to start it as an administrator by clicking Start, clicking All Programs, right-clicking Internet Explorer, and then clicking Run as administrator.
To access Report Manager, reports, or Web sites for SQL Server Reporting Services, you might need to add these sites to the list of trusted sites in Internet Explorer.
To verify or correct credentials or to enable data sources for Reporting Services
Log on to the server that hosts Reporting Services.
Open Internet Explorer, type the following string in the Address bar, and press ENTER:
https://localhost/Reports
If you have deployed a named instance on the data-tier server, type the following string instead:
https://localhost/Reports_TFSInstance
The Web site for Report Manager opens.
Click Tfs2010ReportsDS.
Select the Enable this data source check box, and then click Apply.
In the Connection string box, update the Data source argument with the name of the server that hosts the instance of SQL Server that your deployment of Team Foundation uses.
For example, type the following string:
Data source=NameOfTeamFoundationDatabaseServer\TFSInstance
The Initial Catalog should be set to Tfs_Warehouse.
On the Properties tab, select the Credentials stored securely in the report server check box.
Update the user name and password to match the service account for Reporting Services, and then click Apply.
Repeat steps 3 through 7 for Tfs2010OlapReportDS.
In the Connection string box, update the Data source argument with the name of the server that hosts SQL Server Analysis Services.
For example, type the following string:
Data source=NameOfAnalysisServicesServer\TFSInstance
The Initial Catalog should be set to Tfs_Analysis.