TFS 2010: What Service Packs and Hotfixes Should I Install?

Team Foundation Server 2010 was released in April 2010. Since then, there have been a number of important Service Packs, Cumulative Updates and hotfixes that have been made available based upon internal usage at Microsoft and customer feedback via the support organisation. This blog post is an attempt at bringing together all the updates that are currently available.

Installation Guide

For a new install, you should always start with the latest version of the Installation Guide. The version on the web is newer than the version that's included on the DVD/ISO.


If you have questions about the licensing around Team Foundation Server, you should take a look at the following sources:

Application Tier

Although this is a link to the trial edition ISO, it's the same bits that are used for the non-trial edition. The trial lasts for 90 days and you Upgrade from the Trial Edition by entering your product key at any time. If you're having trouble getting your product key, you can request a trial extension by following these instructions.

The following updates must be installed in the correct order:

KB2719584 addresses the XSS vulnerability in Team Web Access described in MS12-061.

Database Tier

Team Foundation Server 2010 requires SQL Server 2008 Service Pack 1 or later (TFS installation will block if you don't have it installed). 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. (See the bottom of this post for more details if you're interested)

Although TFS 2010 shipped with SQL Server 2008, the R2 edition of SQL Server has been subsequently released. After an update to the Microsoft Product Use Rights document, you can now use SQL Server 2008 R2 with TFS 2010:


Visual Studio Team Foundation Server 2010 includes the right to use one instance of SQL Server 2008 Standard or SQL Server 2008 R2 Standard in support of Team Foundation Server, as permitted in the Universal License Terms section for products that include SQL Server technology.

Note: There may be Cumulative Updates that have been released after a Service Pack. 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.

If for some reason, you can’t run SQL Server 2008 SP3 or at least SQL Server 2008 R2 SP1, AND you are using SQL Enterprise Edition, you should take a look at this KB on possible data corruption issues and recommended minimum patching levels.

Clients (Visual Studio & Microsoft Test Manager)

Visual Studio 2010

(Note: If you have a license key for full version of Visual Studio 2010 Professional, the Visual Studio 2010 Professional Trial - Web Installer includes Team Explorer and it can be more convenient than downloading and mounting the ISO file)

The following updates must be installed in the correct order:

The MSSCCI Provider allows non-Microsoft tools to connect to TFS:

Team Explorer Everywhere (TEE) is an Eclipse IDE/Java implementation of the TFS client:

Visual Studio 2008

The following updates must be installed in the correct order:

Visual Studio 2005

The following updates must be installed in the correct order:

Build Controllers, Build Agents, Test Controllers & Test Agents

A Team Build 2008 server cannot communicate with a Team Foundation Server 2010 server, as such all existing Team Build servers will need to be upgraded.

The following updates must be installed in the correct order:

If you work in a cross-platform environment, you may also want to install the build extensions that allow you to execute Ant or Maven 2 builds and publish any JUnit test results back to TFS.


For the latest recommended updates to SharePoint Server 2010 and Windows SharePoint Services 3.0, see the Office Update Center. You should at least have these:

Feature Pack for Team Foundation Server and Project Server Integration

Only those machines that have the feature pack installed can participate in data synchronization between the two products. See the Configuration Quick Reference for installation pre-requisites and instructions.

Office Project Server 2007

Office Project Server 2010

Process Templates

Visual Studio 2010 Ultimate and Test Professional 2010

Hopefully you find this list of updates useful. If there is something that I’ve missed or you think should be on here, leave a comment or send me an email and I'll do my best to include it.

Brian Harry also has a blog post as of March 2012 which talks about all these patches and the philosophy.

[Update 4 Jan 2012]: Fixed SQL08 R2 SP1 link, added note about SQL CU's, added file types (e.g. ISO) and file sizes.
[Update 9 Jan 2012]: Added SQL08 R2 SP1 CU4 as recommended, since it addresses a ghost record cleanup issue. Added some other patches and feature packs.
[Update 16 Jan 2012]: Replaced TFS SP1 CU1, VS2010 SP1 TFS Compatibility GDR and Test attachment data hotfix with TFS SP1 CU2 link.
[Update 29 Jan 2012]: Updated link to Test Attachment Cleaner to point to the TFS 2010 Power Tools, since it’s now included there.
[Update 31 Jan 2012]: Fixed link to VS2010 SP1 ISO and ISO Mounting instructions.
[Update 2 Feb 2012]: Added link to corruption issues with SQL Enterprise editions. The previous SQL recommended patch levels include this patch, so they are unchanged. Added links to SharePoint service packs and cumulative updates.
[Update 25 Mar 2012]: Added link to VS2010 SP1 TFS 11 Compatibility GDR. Added links to updated licensing rules (TEE, TFS reporting). Updated section titles to clarify where the updates apply to.
[Update 29 Mar 2012]: Fixed links to Project Server feature packs on MSDN.
[Update 26 July 2012]: Updated from SQL 2008 R2 SP1 to SQL 2008 R2 SP2.
[Update 17 Sep 2012]: Replaced TFS 2010 SP1 CU2 with KB2719584 for TFS Server only. Renamed client compatibility update from ‘11’ to ‘2012’
[Update 12 Oct 2012]: Added link to SP1 GDR for testing tools
[Update 8 Oct 2013]: Added link to optional TFS 2010 SP1 Hotfix rollup if you're experiencing the issues that it addresses.

Comments (13)
  1. ErikEJ says:

    What a great post, I am just about to install TFS 2010, and was looking for this!

  2. Matt Ring says:

    Thanks Grant!  This was extremely helpful!

  3. Matt Ring says:

    Grant – It looks like there have been cumulative updates to SQL 2008 R2 since SP1 (Cumulative Update 3 was published October, 2011).  Any known issues with TFS in upgrading past SQL 2008 R2 SP1?

  4. @Matt – Thanks for the comment, glad you found the page useful.

    RE: SQL Cumulative Updates. I updated the page with a note. The SQL team recommends that you only install Cumulative Updates if they address a specific issue that is impacting you. This is because they don't receive the same rigour of testing as a full Service Pack.

  5. Steven Borg says:

    Great post, Grant!  Very, very helpful!  I had just put up a post with some links to basic TFS downloads. This is much more complete.  Have edited my blog to point to your blog as the more complete source of truth.

  6. Awesome list Grant.  FYI the link for the VS 2010 SP1 ISO is incorrect, it should be

  7. @Optikal325235 – Thanks! I found another broken link too.

  8. Brad says:

    Do you plan to update this for CU2 that just came out? Also it would seem some items need to be installed on build agents vs build controllers could you delineate those groups? Last thing add test controllers. This is a handy guide thanks.

  9. Terje Sandstrom says:

    Great post!  

    Brad: The CU2 is in this post, but not the new GDR, which was just released, see Brian H.'s blogpost…/keeping-your-tfs-2010-up-to-date-as-of-march-2012.aspx  

    I have collected the essentials (not as detailed as Grants) but have in addition a nice set of the most common extensions at…/visual-studio-amp-tfs-ndash-list-of-addins-extensions-patches.aspx for VS2010

  10. Dylan Smith says:

    The link to the Project Server Feature Pack is broken (both x86 and x64 versions).

  11. Dylan Smith says:

    Ignore last comment, figured out you just have to be logged in to MSDN first.

  12. Allen Feinberg says:

    Shouldn't the article be updated to include CU#7 for SQL Server 2008 R2?…/KBHotfix.aspx

  13. Grant says:

    @Allan – If you are affected by the data corruption issue (that SQL 2008 RTM CU7 addresses), my recommendation is that you upgrade to SQL 2008 R2 SP1 CU4, since that includes the fix along with others.

    I updated the post on 2 Feb to link to the TFS KB article on the issue (…/2668489)

Comments are closed.

Skip to main content