Set up SQL Server for TFS

SQL R2 installation

How to set up SQL Server

Install SQL Server 2012 SP1 for Team Foundation Server with reporting.

If you’re using SQL Server 2012 with SP1, we recommend you also apply cumulative update 2 on top of SP1 to address a critical SQL Server bug around resource consumption. This isn’t a requirement because the bug only affects a small number of instances, but we wanted you to be aware of it.

Upgrade tips for SQL Server

  • Make sure the default collation settings in SQL Server match the existing settings from the SQL Server instance that you’re migrating from. For more information, see: SQL Server Collation Requirements for Team Foundation Server

  • Make sure your data compression settings in the new SQL Server instance are the same as they were in the previous instance, especially if you’re changing from Enterprise edition to a different SQL Server edition.

Required Permissions

You must be a member of the Administrators security group on Windows Server.

  1. Insert the installation DVD for a supported version of SQL Server and launch setup.exe.

    More information: SQL Server requirements for Team Foundation Server.

  2. On the SQL Server Installation Center page, choose Installation, and then choose New installation or add features to an existing installation.

    New installation of SQL Server

  3. On the Setup Support Rules page, choose OK.

  4. On the Product Key page, type your product key or specify a free edition.

  5. On the License Terms page, accept the license agreement.

  6. On the SetupSupport Rules page, choose Next.

    Windows Firewall warning


    A Windows Firewall warning might appear, but you can safely ignore this warning. TFS automatically adds an exception for Windows Firewall during upgrade in this topology.

  7. On the Setup Role page, choose SQL Server Feature Installation.

    Setup role

  8. On the Feature Selection page, select the following check boxes:

    • Database Engine Services (required)

    • Full-Text and Semantic Extractions for Search (required)

    • Analysis Services (required for reporting)

    • Reporting Services – Native (required for reporting)

    • Management Tools - Basic (not pictured)

    Feature Selection

  9. On the Installation Rules page, choose Next.

  10. On the Instance Configuration page, choose Default instance. If you choose Named instance, type the name of the instance..

    Instance configuration

  11. On the Disk Space Requirements page, choose Next.

  12. On the Server Configuration page, accept the defaults.

    Server Configuration

  13. In the Startup Type column, verify that Automatic appears for all services that you can edit, and then choose Next.

    Server Configuration (details)


    Are you using a non-English version of SQL Server? The default collation settings for U.S. English meet the requirements for Team Foundation Server. If you’re not using English, you can set collation settings for the Database Engine on this page. For more information, see SQL Server Collation Requirements for Team Foundation Server.

  14. On the Database Engine Configuration page, choose Windows authentication mode, choose Add Current User.

    Database Engine Configuration

  15. On the Analysis Services Configuration page, choose Add Current User.

    Analysis Services Configuration

  16. On the Reporting Services Configuration page, choose Install and configure.

    Reporting Services Configuration

  17. (Optional) On the Error and Usage Reporting page, specify whether to send information about errors.

  18. On the Installation Rules page, choose Next.

  19. On the Ready to Install page, review the list of components to be installed, and then choose Install.


Next Step: Set up SharePoint

If you don’t skip the portal setup, you have two options for how to deal with SharePoint (if you don’t want to deal with SharePoint, you can move on to step 4, Back up and restore data for TFS):

Use the same SharePoint site for TFS that you have right now

If your old SharePoint server is still up and running, you can continue to use it. Go to the SharePoint server and uninstall old extensions, and then install the new extensions before you upgrade TFS. If SharePoint and the previous version of TFS were on the same computer, you have to uninstall the entire TFS 2010 application tier. In the new upgraded configuration, the only TFS component on the SharePoint server will be the TFS extensions for SharePoint.

For more information, see: Use the same SharePoint site for TFS that you have right now

install new TFS extensions

Move SharePoint to New Hardware for TFS

You can install SharePoint Foundation using the TFS extensions for SharePoint wizard. The TFS wizard will install a fresh copy of SharePoint using the installation of SQL Server you just set up, and then configure the TFS extensions for the new installation of TFS. After you install SharePoint, you’ll detach its content database to prepare for the migration of the data from your previous SharePoint installation in step 4, Back up and Restore Data.

For more information: Move SharePoint to new hardware for TFS

install new SharePoint 2010