Manually Installing SQL Server for Team Foundation Server
Visual Studio Team Foundation Server requires SQL Server 2008. You have multiple options:
You can use the basic configuration of Team Foundation Server, which comes with SQL Server Express.
You can install SQL Server 2008.
You can use an existing installation of SQL Server 2008.
Regardless of which option you choose, your instance of SQL Server must meet the following requirements:
Supported Service Pack level
Required for Team Foundation Server
Required for reporting
For more information, see SQL Server Collation Requirements for Team Foundation Server.
You can use a domain account or a built-in account.
¹ Limited or no SQL Server High Availability support.
² If you’re using SQL Server 2008, Enterprise Edition, you need to update to cumulative update package 6 for SQL Server 2008 Service Pack 1 or newer, or SP2 to address a SQL Server issue with table compression.
³ If you’re using SQL Server 2008, R2 Enterprise Edition, you need to update to cumulative update package 1 for SQL Server 2008 R2 Service Pack 1 or newer to address a SQL Server issue with table compression.
In Team Foundation Server 2010, a lot of work went into making Team Foundation Server independent of the SQL Server configuration, especially regarding its HA features. The goal was that Team Foundation Server would work without any HA-specific configurations, no matter which HA feature you used. The reality is that the breadth of HA features in SQL Server is too great to pledge support for all of them. The following table lists the SQL Server HA features supported by TFS:
SQL Server HA feature
SQL Log Shipping