Team Foundation Server

Server Software / Purpose
Microsoft SQL Server 2005 (Standard or Enterprise Edition) / Provides database back-end for Team Foundation Server and Windows SharePoint Services.
Microsoft SQL Server 2005 hotfix / Updates SQL Server Analysis Services to provide more efficient reporting. Microsoft SQL Server 2005 Service Pack 1 includes this hotfix. Also, you can get the hotfix on the Team Foundation Server installation media. Use Microsoft SQL Server 2005 SP1 because it provides improved performance along with the required hotfix.
.NET Framework 2.0 hotfix KB913363 / Updates ASP.NET to enable more efficient handling of large files.
Windows SharePoint Services 2.0 with Service Pack 2 / Hosts team project portal sites.

Required Accounts

Before you install Team Foundation Server, identify the accounts you are going to use during setup. This installation guide refers to these accounts by a placeholder name as noted in the table.

Note
You do not have to use the sample user logon names. If you want to use different user logon names, or if you have existing accounts you can use, make sure that you substitute the correct name as appropriate during setup.
Sample user logon name / Purpose
TFSSETUP /
  • Used to run Team Foundation Server Setup.
This account must be an administrator on Team Foundation Server computers.The account must be a member of the same domain as the following two service accounts. For example, you cannot have the two service accounts on a domain and then use a local account to run setup.
  • If you are installing the Team Foundation Server Workgroup Edition, addsthis account to the Team Foundation Licensed Users group. For this reason, you shouldrun Setup withyour user account.

TFSSERVICE /
  • Used as the service account by Team Foundation Server Windows services (Code Coverage Analysis Service and TFSServerScheduler), and the SharePoint Timer Service.
  • Used as the application pool identity by the Team Foundation Server application pool (TFS AppPool), and the Windows SharePoint Services application pools (TFWSS and TFSWSSADMIN).
For optimal security, this service account:
  • Should not be an administrator on Team Foundation Server computers.
  • Should have the option Account is sensitive and cannot be delegated selected for Active Directory on the domain.

TFSREPORTS /
  • Used as the service account by SQL Server Reporting Services data sources.
  • This account should not be an administrator on Team Foundation Server computers.

TFSPROXY /
  • Used by Team Foundation Server Proxy on a computer that is not a member of the same domain as the Team Foundation Server application-tier and data-tier components.
  • This service account must be a member of the Administrators group on the remote computer.
  • This account must be added as a member of the Service Accounts group for the Team Foundation Server that uses the proxy.

Team Foundation Server Security Groups

Team Foundation Server security is managed by Team Foundation Server security groups. Thesegroups differ from Windows domain or local security groups.

Team Foundation Server Security Group / Description
Team Foundation Administrators /
  • This group contains users who can perform all privileged operations on the server.
  • By default, setup adds the account that is used to run setup (for example, Domain\TFSSETUP) to this group.

Service Accounts /
  • This group contains Team Foundation Server service accounts, such as the application pool identities for Team Foundation Server Web services (for example, Domain\TFSSERVICE).

Team Foundation Valid Users /
  • This group contains all users and groups that have access to the server.

Team Foundation Server Setup adds the user account that is used to run setup (for example, Domain\TFSSETUP) to the Team Foundation Administrators group. To add other users to this group, you must use an account that is already a member of Team Foundation Administrators. After setup is completed, you must log on using the same account that was used to run setup (for example, Domain\TFSSETUP) to add the initial new members to the Team Foundation Administrators group.

Prerequisites

You need the following equipment and information in order to complete installation.

  • Printed version of Checklist: Team Foundation Server Single-Server Deployment.
  • One computer that meets the hardware and software requirements for the size of your team. For more information, see System Requirements for Team Foundation (Single-Server).
  • Two service accounts for Team Foundation Server. For more information, see, User Accounts Required for Team Foundation Server Setup. Microsoft SQL Server 2005 also requires a service account, but you can use the built in accounts.
  • A user account for completing setup that is a member of the Administrator security group on the computer.
  • Check the status of the firewall so that you know whether you need to open ports explicitly.

Summary of Installation Procedures

To install the data tier components

  1. Log on to Windows by using the user account you identified for completing setup.

This guide uses the placeholder Domain\TFSSETUP for this account.

  1. Install Internet Information Services (IIS) with ASP.NET enabled.
  2. Install Microsoft SQL Server 2005 Standard or Enterprise Edition.
  3. Install the hotfix for Microsoft SQL Server 2005, enable, and restart the SQL Browser service.
  4. Install the hotfix for Microsoft .NET Framework 2.0.
  5. Install Windows SharePoint Services 2.0 with Service Pack2.
  6. Install Team Foundation Server.

Installing Internet Information Services (IIS)

Your application-tier computer may already be configured as an application server. If the Windows component, Internet Information Services (IIS), is already configured, enable ASP.NET if it is not enabled already. Otherwise, follow this procedure to install IIS and enable ASP.NET.

To install IIS using Add or Remove Programs utility

  1. From Control Panel, open Add or Remove Programs.
  2. Click Add/Remove Windows Components.

The Windows Components Wizard starts.

  1. On the Windows Components page, highlight and select Application Server, and then click Details.
  2. If not already selected, select ASP.NET, and then click OK.

Important
If you select Internet Information Services (IIS) and then click Details, do not select FrontPage 2002 Server Extensions. This server will host Windows SharePoint Services that is incompatible with FrontPage Server Extensions.
  1. On the Windows Components page, click Next.

Note
You may be prompted for your Windows Server 2003 installation media.
  1. Click Finish to close the wizard.
  2. Visit Windows Update ( and install all items in the Critical Updates and Service Packs group.

Installing Microsoft SQL Server 2005

After meeting the prerequisites, you can install Microsoft SQL Server 2005 Standard or Enterprise Edition. Team Foundation Server includes a licensed copy of Microsoft SQL Server 2005 Standard Edition.

Note
The following procedure assumes you have physical installation media available. If you are installing from a network share, you must adjust the steps accordingly.

To install Microsoft SQL Server 2005 interactively

  1. Insert the CD for Microsoft SQL Server 2005 and under Install on the SQL Server 2005 Start page, click Server components, tools, Books Online, and samples.

Note
The CD for Microsoft SQL Server 2005 Standard edition is available with Team Foundation Server. To install SQL Server Enterprise, you can use the CD from the software you purchased separately. The Start page is available by running the Splash.hta file located in the Servers folder of the installation media.
  1. The Microsoft SQL Server 2005 Setup wizard starts.
  2. On the End User License Agreement page, review the license agreement. If you accept the terms and conditions, select I accept the license terms and conditions, and then click Next.
  3. On the Installing Prerequisites page, click Install. After the required components are installed successfully, click Next.

The Microsoft SQL Server Installation Wizard starts.

  1. Click Next to start the System Configuration Check.
  2. On the System Configuration Check page, examine the status of any required actions, such as required system restarts, and follow the guidance on this page until all actions achieve Success status. After all actions achieve Success status, click Next to start installation.

Note
The installer may take several moments to start.
  1. On the Registration Information page, complete the registration information, and then click Next.
  2. On the Components to Install page, select the following components, and then click Advanced.
  3. SQL Server Database Services
  4. Analysis Services
  5. Integration Services
  6. Reporting Services
  7. Workstation components, Books Online, and development tools

Note
Notification Services are not required by Team Foundation Server.
  1. On the Feature Selection page, expand the following nodes and specify the following options.

Note
Except as noted in this section, you should not change the default selections in any other feature areas.
  1. Under Client Components, the only required feature to install is Management Tools. For all other items under Client Components, you can optionally click the icon and select Entire feature will be unavailable.
  2. Under Documentation, Samples, and Sample Databases, you can optionally click the icon for Books Online, and select Entire feature will be unavailable. Click Next.

Note
To optimize system performance, select Data Files, and then click Browse to specify a file location on a different physical hard disk. By default, SQL Server 2005 installs all files to the system drive. You can do the same for Data Files under Analysis Services.
  1. On the Instance Name page, select Default instance, and then click Next.

Important
Team Foundation Server setup fails if you specify a named instance.
  1. On the Service Account page, clear the Customize for each service account option. Select Use the built-in System account and from the list select Local system. In Start services at the end of setup, select all services: SQL Server, SQL Server Agent, Analysis Services, Reporting Services, and SQL Browser, and then click Next.

Note
The service account is for Microsoft SQL Server 2005 and should not be confused with the two service accounts you obtained before starting installation.
  1. On the Authentication Mode page, select Windows Authentication Mode, and then click Next.
  2. On the Collation Settings page, select the appropriate collation for your language, and then click Next.

Note
If you change Collation designator and sort order, you must select Accent Sensitive.
  1. The default choice is based on the setting for non-Unicode language in WindowsServer2003. The default for most languages is a Windows collation, however, for U.S. English, SQL Server 2005 installs with a SQL Server collation for backwards-compatibility. If you want to change the collation from the default to get support for additional U.S. English characters, consider Latin1_General.
  2. For other languages, consider an "_90" Windows collation when available, otherwise use another Windows collation.
  1. On the Report Server Installation Options page, select Install the default configuration, and then click Next.
  2. On the Error and Usage Report Settings page, you can optionally select Automatically send Error reports for SQL Server 2005 to Microsoft or your corporate error reporting server and Automatically send Feature Usage data for SQL Server 2005 to Microsoft, and then click Next.
  3. On the Ready to Install page, you can review the list of components to be installed, and then click Install.
  4. On the Setup Progress page, you can monitor the installation status of each component. After setup has completed, click Next.

Note
Installation may appear to stop responding for several minutes during activation of SQL Server Reporting Services.
  1. Click Finish to exit the wizard.

Installing the Microsoft SQL Server 2005 Hotfix

After you install Microsoft SQL Server 2005, you must install the hotfix that updates SQL Server Analysis Services that supports reporting more efficiently. The hotfix is included in Microsoft SQL Server 2005 Service Pack 1 or available on the Team Foundation Server installation media. Microsoft SQL Server 2005 SP1 provides improved performance along with the required hotfix. Be sure to read the preparation steps and installation instructions for the service pack ( For more information about downloading Microsoft SQL Server 2005 SP1, visit the Microsoft Download Center (

If you do not install this Service Pack, you must complete the following procedure to install the hotfix.

To install the Microsoft SQL Server 2005 hotfix

  1. On the data-tier computer, open SQL Server Configuration Manager, right-click SQL Server Browser Service, and then click Stop.
  2. On the Team Foundation Server installation media, locate the SQLServerKB folder.
  3. Locate the executable file (.exe) for your operating system and language, such as AS2005-KBnnnnnn-x86-ENU.exe, and then double-click the file to start the Hotfix Installer.
  4. In the Hotfix Installer, accept the End User License Agreement, complete the pages to install the hotfix, and then click Finish.
  5. Open the Windows Services Manager, right-click SQL Server Browser Service, and click Properties.
  6. On the General tab, locate the Startup type, select Automatic, and then click Start.

To verify your installation before you install Windows SharePoint Services, see How to: Verify Microsoft SQL Server 2005 Installation.

Installing the Microsoft .NET Framework 2.0 Hotfix

You must install the hotfix that updates ASP.NET to support the handling of large files more efficiently.

Note
You might want to visit the Web for the latest updates to Team Foundation Server.

To install the Microsoft .NET Framework 2.0 hotfix

  1. On the application-tier computer, locate the folder KB913393 on the Team Foundation Server installation media.
  2. Locate the executable file (.exe) for your operating system (X86), and then double-click the file to install.

Installing Microsoft Windows SharePoint Services

Follow these steps to install Microsoft Windows SharePoint Services with Service Pack 2 for Team Foundation Server to interactively use the setup wizard, or to run silently from the command line.

Important
Windows SharePoint Services requires an NTFS file system.

To install Windows SharePoint Services interactively

  1. Log on to Windows by using the Team Foundation Server Setup account; for example, Domain\TFSSETUP.
  2. Download Microsoft Windows SharePoint Services with Service Pack 2 ( and save the file to the local hard disk.
  3. Run the downloaded self-extracting installer file (stsv2.exe).
  4. On the End-User License Agreement page, review the license agreement. If you accept the terms and conditions, select I accept the terms in the License Agreement, and then click Next.
  5. On the Type of Installation page, select Server Farm, and then click Next.

Important
You must install Windows SharePoint Services by using the Server Farm option. This configures Windows SharePoint Services to use a remote SQL Server. Later, Team Foundation Server Setup will configure Windows SharePoint Services to use the same instance of SQL Server as the rest of Team Foundation Server.
  1. On the Summary page, click Install.

When the installation is complete, a Web browser window opens and displays the Configure Administrative Virtual Server page. After confirming that the page appears, close the browser window without making any changes.

Important
Do not make any changes on the page that appears. Later, Team Foundation Server Setup will configure Windows SharePoint Services to use the same instance of SQL Server as the rest of Team Foundation Server.

If the page does not appear, you should determine the cause and troubleshoot using the Windows SharePoint Services Administrator's Guide (

  1. Visit Windows Update ( and install all items in the Critical Updates and Service Packs group.
  2. Restart the computer

Installing Team Foundation Server

After you install all the related components, you can install Team Foundation Server.

Note
The procedure below assumes you have physical installation media available. If you are installing from a network share, you must adjust the steps accordingly.

To install Team Foundation Server

  1. Log on to Windows by using the Team Foundation Server Setup account; for example, Domain\TFSSETUP.
  2. Insert the CD, on the Autorun page that appears, click Install Team Foundation Server, and then click Single-Server Installation.

If the Autorun page does not appear, locate and run the autorun file (autorun.exe) in the root folder on the installation media.