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 SQL Server and Team Foundation database. These topics show you how you can resolve the errors, warnings, and non-default configurations that the tool finds.
For a summary of the information that the tool reports for health and preinstall checks, see Information Messages About Team Foundation.
In This Section
A database role for SQL Server is missing
A SQL Server service is installed on the application-tier server
A SQL Server service is not installed
A SQL Server service is not set for automatic startup
A SQL Server service is stopped
A SQL Server service is stopped on the data-tier server
The Team Foundation database is not configured correctly
Expected stored procedures are missing
Number of users might affect performance
SQL Server is not listening for remote connections using TCP/IP
SQL Server service is not set to use Local System account
Team Foundation Database Version Information
Team Foundation Server does not support collation setting
The SQL Server instance is named
The Team Foundation database is not configured correctly
The version of SQL Server on the data-tier server is not compatible
Unexpected stored procedures were found
Related Sections
Issues That Relate to the Application Tier for Team Foundation
Describes the rules that the tool evaluates with respect to the installation of software and services on the application-tier server and provides guidance for how you can resolve errors and warnings that the tool reports.Issues That Relate to SQL Server Reporting Services
Describes the rules that the tool evaluates with respect to SQL Server Reporting Services and provides guidance for how you can resolve errors and warnings that the tool reports.