A SQL Server service is stopped
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
Application-tier server
Data-tier server
Health check
Preinstall check
The Best Practices Analyzer tool for Team Foundation Server queries the Windows Management Instrumentation (WMI) classes to determine the state of the SQL Server services that are running on the servers that you specified for the scan. An error appears if a required SQL Server service is stopped.
You must resolve this error condition before you install Team Foundation Server. The following table indicates the error messages that might appear. To resolve this error condition, you must restart the service on the indicated server.
Error message |
Server (Visual Studio 2005 Team Foundation Server) |
Server (Team System 2008 Team Foundation Server) |
|---|---|---|
SQL Full Text Search service is stopped |
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 stopped |
Data tier |
Data tier |
SQL Server Analysis Services service is stopped |
Data tier |
Data tier or server on which SQL Server Analysis Services is running. |
SQL Server Browser service is stopped |
Data tier |
Data tier (optional) Note The SQL Server Browser service might not be deployed. Corporate security policies sometimes mandate running SQL Server without SQL Server Browser service. SQL Server Browser service maps SQLDatabaseServer/InstanceName to a specific server and port number. |
SQL Server Integration Services service is stopped |
Data tier |
Not applicable |
SQL Server Reporting Services service is stopped |
Application tier |
Application tier or server on which SQL Server Reporting Services is running. |
SQL Server service is stopped |
Data tier |
Data tier |
If you cannot start a service, check the event logs for more information about the failure. Be sure to install the most recent service pack for your version of Team Foundation Server. You might have used an incorrect or expired password for a service account. These scenarios are more likely if other services that use the same account have not started either. For more information, see An account password has expired or is about to expire.
Required Permissions
To perform these procedures, you must be a member of the Administrators security group on the data-tier or application-tier server for Team Foundation.
To start a SQL Server service that is stopped
Log on to the server where the service is stopped.
Open the Start menu, point to Administrative Tools, and click Services.
Services opens.
Right-click the service that is not running, and click Start.
Close the Services snap-in.
See Also
Other Resources
Issues That Relate to the Application Tier for Team Foundation
Issues That Relate to SQL Server and the Team Foundation Database