Issues that Relate to SQL Server and the Team Foundation Database

The topics in this section describe how the Best Practices Analyzer tool for Team Foundation Server evaluates the configuration of the server that hosts the databases for Team Foundation. These topics show you how you can resolve the errors, warnings, and non-default configurations that the tool finds when you run the following types of scans:

  • Team Foundation Server Complete Health Check

  • Team Foundation Server Framework Health Check

  • Team Foundation Server Warehouse Health Check

For a summary of the information that the tool reports for health checks, see Information Messages About Team Foundation.

In This Section

A database role for SQL Server is missing

Number of users might affect performance

Team Foundation Database Version Information

The Team Foundation database is not configured correctly

The versions of SQL Server databases do not match

SQL Server Reporting Services is not configured correctly