SQL Server Reporting Services service is 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
Dual-server deployment
Application-tier server
Health check
The Best Practices Analyzer tool for Team Foundation Server checks the configuration of the service for SQL Server Reporting Services in dual-server deployments. For Visual Studio 2005 Team Foundation Server, the rule checks the application-tier server. For Visual Studio Team System 2008 Team Foundation Server, the rule checks the server where SQL Server Reporting Services is installed.
An error appears if the service for SQL Server Reporting Services is set to use a Local System account. For all dual-server deployments, the Log on as property of the service for SQL Server Reporting Services must be set to a Network Service account or a valid domain account.
To resolve this issue, you must configure the service for SQL Server Reporting Services to use either a Network Service or a valid domain account.
To change the Log on as property of the service for SQL Server Reporting Services
On the application-tier server, click Start, click Administrative Tools, and click Services.
The Services Microsoft Management Console (MMC) opens.
Right-click SQL Server Reporting Services (MSSQLSERVER), and then click Properties.
The SQL Server Reporting Services (MSSQLSERVER)Properties window opens
Click the Log on tab.
Click This account, type either NT AUTHORITY\NetworkService or a valid domain account and its password, and then click OK.
Close the Services console.
See Also
Other Resources
Issues That Relate to the Application Tier for Team Foundation