The general recommendations from the SQL Server team are that you should a) Install the latest released Service Pack for your version of SQL b) Only install SQL Cumulative Updates when you encounter a specific issue that is addressed by that Cumulative Update. Note: There may be Cumulative Updates that have been released after a Service Pack.
After an update to the Microsoft Product Use Rights document, you can now use SQL Server 2008 R2 with TFS 2010: SQL Server 2008 Service Pack 3 (372 MB)Īlthough TFS 2010 shipped with SQL Server 2008, the R2 edition of SQL Server has been subsequently released.(See the bottom of this post for more details if you’re interested)
If your IT department requires you to use SQL Server 2008 (rather than 2008 R2) it is recommended to install at least SQL Server 2008 Service Pack 2, as it includes a number of important fixes that TFS benefits from. Team Foundation Server 2010 requires SQL Server 2008 Service Pack 1 or later (TFS installation will block if you don’t have it installed). Along with all the issues addressed in TFS 2010 SP1 CU2 (KB2643415), it also addresses the XSS vulnerability described in MS12-061.
KB2719584 is a cumulative update and replaces previous cumulative updates for TFS 2010 SP1. Recommended: Team Foundation Server 2010 SP1 Security Update KB2719584 (1.3 MB).Recommended: Team Foundation Server 2010 SP1 (477 MB).The following updates must be installed in the correct order:
If you’re having trouble getting your product key, you can request a trial extension by following these instructions.
The trial lasts for 90 days and you Upgrade from the Trial Edition by entering your product key at any time.