SQL Server service is not set to use Local System account
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 configuration of the service for SQL Server. A warning appears if the Log on as property that is assigned to the SQL Server service does not match the expected built-in system account. This warning indicates only that the configuration does not match the recommendation in the Team Foundation installation guide. The SQL Server service does not have be set to Local System.
Note
This warning will not appear if the data-tier is deployed on a server cluster.
To resolve this issue, reset the Log on as property of the service for SQL Server (MSSQLSERVER or TFSInstance) to Local System.
Note
For Visual Studio 2005 Team Foundation Server, the default instance MSSQLSERVER is always used. For Visual Studio Team System 2008 Team Foundation Server, either the default or named instance, TFSInstance, is used.
Required Permissions
To perform this procedure, you must be a member of the Administrators group on the server that you log on to.
To change the Log on as property of the service account for SQL Server
Log on to the computer that the error specifies.
Open the Start menu, point to Administrative Tools, and click Services.
The Services Microsoft Management Console (MMC) opens.
Right-click SQL Server (MSSQLSERVER or TFSInstance**)**, and then click Properties.
Click the Log on tab, and then click Local system account.
Click Apply, and then click OK.
Right-click SQL Server (MSSQLSERVER or TFSInstance**)**, and then click Restart.
Close Services.