Tim Elhajj

Off the Microsoft stack!

Set Up SQL Server for TFS (RTM)


How to set up SQL Server

First you install and configure SQL Server 2008 R2 for Team Foundation Server with reporting. If you’re using SQL Server 2008 R2 Enterprise edition, you have to update to cumulative update package 1 for SQL Server 2008 R2 Service Pack 1 (or a later version) to address a SQL Server issue with table compression.

After you complete the install, you  configure Windows Server to recover analysis services on failure.

 Tip: Make sure the default collation settings in SQL Server match the existing settings from the SQL Server instance that you’re migrating from. There’s more information about this on MSDN: SQL Server Collation Requirements for Team Foundation Server

Required Permissions

To perform these procedures, you must be a member of the Administrators security group on Windows Server.

To install Database Engine, Analysis Services and Reporting Services
  1. Launch setup.exe on the SQL Server DVD.
  2. On the SQL Server Installation Center page, choose Installation, and then choose New installation or add features to an existing installation.
  3. On the Setup Support Rules page, choose OK.
  4. On the Product Key page, type your product key or specify a free edition and then choose Next.
  5. On the License Terms page, accept the license agreement and choose Next.
  6. On the Setup Support Files page, choose Install.
  7. On the Setup Support Rules page, choose Next.
    Tip
    : A Windows Firewall warning might appear here, but you can safely ignore this warning. TFS automatically adds an exception for Windows Firewall during upgrade.
  8. On the Setup Role page, choose SQL Server Feature Installation and then choose Next.
  9. On the Feature Selection page, select the check boxes for the following components and then choose Next:

    • Database Engine Services (required for Team Foundation Server)
    • Full-Text Search (required for Team Foundation Server)
    • Analysis Services (required for reporting)
    • Reporting Services (required for reporting)
    • Management Tools – Basic (Management Tools -Complete automatically selects itself when you click Basic and this is fine)
  10. On the Installation Rules page, choose Next.
  11. On the Instance Configuration page, choose Default instance. If you choose Named instance, type the name of the instance. Choose Next.
  12. On the Disk Space Requirements page, choose Next.
  13. On the Server Configuration page, choose Use the same account for all SQL Server services, and enter NT AUTHORITY\NETWORK SERVICE in Account Name for every service.

    • If you do specify a domain account, enter its password in Password.
    • If you use NT AUTHORITY\NETWORK SERVICE, leave Password blank.
    • If you choose Use the same account for all SQL Server services, you might still have to manually enter account information for some services.
  14. In the Startup Type column, verify that Automatic appears for all services that you can edit, and then choose Next.
  15. On the Database Engine Configuration page, choose Windows authentication mode, choose Add Current User, and then choose Next.
  16. On the Analysis Services Configuration page, choose Add Current User, and then choose Next.
  17. On the Reporting Services Configuration page, choose Install the native mode default configuration, and then choose Next.
  18. (Optional) On the Error and Usage Reporting page, specify whether to send information about errors and then choose Next.
  19. On the Installation Rules page, choose Next.
  20. On the Ready to Install page, review the list of components to be installed, and then choose Install.
    The Installation Progress page shows the status of each component.
  21.  On the Complete page, choose Close.

Update SQL Server 2008 R2 Enterprise edition

If you’re using SQL Server 2008 R2 Enterprise edition, you have to update to cumulative update package 1 for SQL Server 2008 R2 Service Pack 1 (or a later version) to address a SQL Server issue with table compression. If you’re using SQL Server 2008 R2 Standard edition or SQL Server 2012, you don’t have to update SQL Server.

Configure Analysis Services to recover on failure

You should configure the Windows service for Analysis Services to restart itself if it fails.

To configure Analysis Services to recover
  1. Open the Services control panel (Start >Administrative tools >Services).
  2. Right-click the Windows service for SQL Server Analysis Services (MSSQLSERVER), and then choose Properties. If you are using a named instance of Analysis Services, the instance name appears in parenthesis.
  3. Choose Recovery.
  4. In the First failure list, choose Restart the Service.
  5. In the Second failure list, choose Restart the Service.
  6. In the Subsequent failures list, choose Restart the Service, and then choose OK.

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 Back up and Restore Data for TFS):

  • Use the same SharePoint site 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 the 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: Use the same SharePoint site that you have right now

  • Move SharePoint to a new server.
    New for this version of 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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s