SQL Server Reporting Services is not configured correctly

The information in this article applies to:

• Visual Studio 2005 Team Foundation Server

• Visual Studio Team System 2008 Team Foundation Server

• SQL Server and SQL Server 2008

• Application-tier server

• Health check

The Best Practices Analyzer tool for Team Foundation Server performs several configuration checks on SQL Server Reporting Services.

An error appears if any of the following conditions occur:

• The TFSReportDS data source does not exist.

• The TFSOlapReportDS data source does not exist.

• The reports within those data sources cannot be accessed.

To resolve missing data sources, you must repair Team Foundation Server. To resolve access to the reports in the data sources, you must verify that the data sources are correctly configured with valid credentials.

Required Permissions

To perform these procedures, you must be a member of the Administrators security group on the data-tier or application-tier server for Team Foundation.

To repair the data sources for SQL Server Reporting Services

• Repair the installation of Team Foundation Server. For more information, see Expected stored procedures are missing.

To verify or correct the credentials of the data sources for SQL Server Reporting Services

1. Start Internet Explorer, and open http://ReportsServerName/Reports.

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

   Replace ReportsServerName with the name of the server where SQL Server Reporting Services is deployed. Typically, you specify the application-tier server.

   Note

   Even if you are logged on with administrative credentials on a server that is running Windows Server 2008, you may need to add the name of the server where SQL Server Reporting Services is deployed to the trusted sites in Internet Explorer or start Internet Explorer as an administrator.

2. On the Contents tab, click TfsReportDS.

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

4. In User name and Password boxes, type the correct credentials.

5. Select the Use as Windows credentials when connecting to the data source check box, and click Apply.

6. Repeat steps 2 through 5 for TfsOlapReportDS.

See Also

Tasks

A service account is not configured correctly

Other Resources

Issues That Relate to SQL Server Reporting Services