A SQL Server service is not set for automatic startup
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 on the servers that you specified for the scan. An error appears if a required SQL Server service is not set to start automatically.
Note
This error will not appear if the data-tier is deployed on a server cluster.
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 change the Startup type property for 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 not set for automatic startup |
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 set for automatic startup |
Data tier |
Data tier |
SQL Server Analysis Services service is not set for automatic startup |
Data tier |
Data tier or server on which SQL Server Analysis Services is running |
SQL Server Browser service is not set for automatic startup |
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 set for automatic startup |
Data tier |
Not applicable |
SQL Server Reporting Services service is not set for automatic startup |
Application tier |
Application tier or server on which SQL Server Reporting Services is running |
SQL Server service is not set for automatic startup |
Data tier |
Data tier |
Required Permissions
To perform this procedure, you must be a member of the Administrators security group on the data-tier or application-tier server for Team Foundation.
To configure a SQL Server service for automatic startup
Log on to the server where the service is installed.
Open the Start menu, point to Administrative Tools, and then click Services.
Services opens.
Right-click the service that the error specifies, and then click Properties.
For example, right-click SQL Server Agent (MSSQLSERVER), and then click Properties.
The properties dialog box for the service opens.
On the General tab, click Automatic in the Startup type list, and then click OK.
Close the Services snap-in.
See Also
Other Resources
Issues That Relate to SQL Server and the Team Foundation Database