Share via

A SQL Server service is installed on the application-tier server

  • Article

The information in this article applies to:

  • Visual Studio 2005 Team Foundation Server

  • Visual Studio Team System 2008 Team Foundation Server

  • SQL Server 2005 and SQL Server 2008

  • Dual-server deployment

  • Application-tier server

  • Preinstall check

The Best Practices Analyzer tool for Team Foundation Server checks the configuration of SQL Server as it is installed on the application-tier server in a dual-server deployment. An error appears if a component of SQL Server is installed on the application-tier server and that component should be installed on the data-tier server.

Note

In a deployment of Visual Studio 2005 Team Foundation Server, several SQL Server components must be installed on the data-tier server. In a deployment of Visual Studio Team System 2008 Team Foundation Server, some of those components can be installed on a server other than the data-tier server.

The following SQL Server components should be installed on the data-tier server:

Visual Studio 2005 Team Foundation Server

Visual Studio Team System 2008 Team Foundation Server

  • SQL Server

  • SQL Server Agent

  • SQL Server Analysis Services

  • SQL Server Browser

  • SQL Server Integration Services

  • SQL Server

  • SQL Server Agent

  • SQL Server Analysis Services (can be installed on a remote server)

  • SQL Server Browser (optional)

  • SQL Server Full Text Search (optional)

    Note

    Full Text Search is an integrated feature in SQL Server 2008. It does not run as a separate service.

  • SQL Server Integration Services (optional)

To resolve this issue, you must uninstall the SQL Server component that the error indicates from the application-tier server. You must resolve this error condition before you install Team Foundation Server.

For more information about how to install prerequisite software for Team Foundation Server, see the installation guide for Team Foundation. To obtain this guide, see Accessing the Team Foundation Installation Guide.

Required Permissions

To perform these procedures, you must be a member of the Administrators security group on the application-tier server.

To uninstall components of SQL Server 2005

  1. Log on to the application-tier server.

  2. Open the Start menu, point to Control Panel, and then click Add or Remove Programs.

  3. Click Microsoft SQL Server 2005, and then click Remove.

  4. On the Component Selection page, under Select an instance, click the instance that you want to remove.

    Note

    Click Report to display a list of the components and features for SQL Server 2005 that are installed.

  5. Under Remove SQL Server 2005 common components, select the check boxes for the components that you want to uninstall, and then click Next.

  6. On the Confirmation page, review the list of components and features to be removed, and then click Finish.

  7. On the Finish page, click Exit.

To uninstall components of SQL Server 2008

  1. Log on to the application-tier server.

  2. Open the Start menu, point to Control Panel, and then click Add or Remove Programs.

  3. Click Microsoft SQL Server 2008, and then click Remove.

  4. On the Component Selection page, under Select an instance, click the instance that you want to remove.

    Note

    Click Report to display a list of the components and features for SQL Server 2008 that are installed.

  5. Under Remove SQL Server 2008 common components, select the check boxes for the components that you want to uninstall, and then click Next.

  6. On the Confirmation page, review the list of components and features to be removed, and then click Finish.

  7. On the Finish page, click Exit.

See Also

Other Resources

Issues That Relate to SQL Server and the Team Foundation Database