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.

참고

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

  1. Log on to the server that hosts Reporting Services.

  2. Open Internet Explorer, type the following string in the Address bar, and press ENTER:

    http://localhost/Reports

    If you have deployed a named instance on the data-tier server, type the following string instead:

    **http://localhost/Reports**\_TFSInstanc

    The Web site for Report Manager opens.

  3. Click Tfs2010ReportsDS.

  4. Select the Enable this data source check box, and then click Apply.

  5. 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.

  6. On the Properties tab, select the Credentials stored securely in the report server check box.

  7. Update the user name and password to match the service account for Reporting Services, and then click Apply.

  8. 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.

See Also

Other Resources

Issues Related to SQL Server Reporting Services