Share via

A SQL Server service is not installed

  • Article

The information in this article applies to:

  • Visual Studio 2005 Team Foundation Server

  • Visual Studio Team System 2008 Team Foundation Server

  • Windows Server 2003 and Windows Server 2008 

  • SQL Server 2005 and SQL Server 2008

  • Application-tier server

  • Data-tier server

  • Health check

  • Preinstall check

For these checks, the Best Practices Analyzer tool for Team Foundation Server checks the configuration of the servers that you specified in the scan. An error appears if a required service for SQL Server is not installed. For Visual Studio Team System 2008 Team Foundation Server, a warning appears if an optional service for SQL Server is not installed or is installed on a remote server.

You must resolve this error condition before you install Team Foundation Server. The following table indicates the errors that might appear and on which server you must install the service.

Error

Server

(Visual Studio 2005 Team Foundation Server)

Server

(Visual Studio Team System 2008 Team Foundation Server)

SQL Full Text Search service is not installed

Data tier

Data tier

Note

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

SQL Server Agent service is not installed

Data tier

Data tier

SQL Server Analysis Services service is not installed

Data tier

Server that hosts SQL Server Analysis Services (likely the data-tier server).

SQL Server Browser service is not installed

Data tier

Data tier (optional)

Note

This service might not be deployed. Corporate security policies sometimes mandate running SQL Server without this service, which maps SQLDatabaseServer/InstanceName to a specific server and port number.

SQL Server Integration Services service is not installed

Data tier

Data tier

Note

This rule is not checked for Visual Studio Team System 2008 Team Foundation Server.

SQL Server Reporting Services service is not installed

Application tier

Server that hosts SQL Server Reporting Services (likely the application-tier server).

Note

This rule is not checked for Visual Studio Team System 2008 Team Foundation Server.

SQL Server service is not installed

Data tier

Data tier

To resolve this issue, you must install the missing service on the appropriate computer for your deployment.

Required Permissions

To perform this procedure, you must be a member of the Administrators security group on the server where you are installing the service.

To install a service for SQL Server

  • For Visual Studio 2005 Team Foundation Server, download the Team Foundation Installation Guide from the Microsoft Download Center, and see the topic that is appropriate for your deployment:

    • How to: Install Microsoft SQL Server 2005 for Team Foundation Server (Single-Server Deployment)

    • How to: Install Microsoft SQL Server 2005 for Team Foundation Server (Dual-Server Deployment)

    • How to: Install Microsoft SQL Server 2005 Reporting Services for Team Foundation Server (Dual-Server Deployment)

  • For Visual Studio Team System 2008 Team Foundation Server, download the Team Foundation Installation Guide from the Microsoft Download Center, and see the topic that is appropriate for your deployment:

    • How to: Install Microsoft SQL Server 2005 (Single-Server Deployment) on Windows Server 2003

    • How to: Install Microsoft SQL Server 2005 (Single-Server Deployment) on Windows Server 2008

    • How to: Install Microsoft SQL Server 2008 (Single-Server Deployment) on Windows Server 2003

    • How to: Install Microsoft SQL Server 2005 (Dual-Server Deployment) on Windows Server 2003

    • How to: Install Microsoft SQL Server 2005 (Dual-Server Deployment) on Windows Server 2008

    • How to: Install Microsoft SQL Server 2008 (Dual-Server Deployment) on Windows Server 2003

    • How to: Install SQL Server Reporting Services (Dual-Server Deployment) on Windows Server 2003

See Also

Other Resources

Issues That Relate to SQL Server and the Team Foundation Database