SQL Server Reporting Services service is not set to use the 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
Single-server deployment
Health check
Preinstall check
The Best Practices Analyzer tool for Team Foundation Server queries Windows Management Instrumentation (WMI) classes to determine the service configuration for SQL Server Reporting Services. An error appears if the Log on as property for that service does not match the expected built-in system account. For a single-server deployment, the expected built-in system account corresponds to the Local System account.
To resolve this issue, reset the Log on as property of the service for SQL Server Reporting Services (MSSQLSERVER or TFSInstance) (ReportServer).
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 for SQL Server Reporting Services
Log on to the computer that the error specifies.
Open Start, point to Administrative Tools, and click Services.
The Services Microsoft Management Console (MMC) opens.
Right-click the SQL Server Reporting Services (MSSQLSERVER) service, and click Properties.
Click the Log On tab, and then click Local System Account.
Click Apply, and then click OK.
Right-click SQL Server Reporting Services, and then click Restart.
Close Services.