Partager via

SQL Server Reporting Services service is set to use Local System account

  • Article

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

  1. On the application-tier server, click Start, click Administrative Tools, and click Services.

    The Services Microsoft Management Console (MMC) opens.

  2. Right-click SQL Server Reporting Services (MSSQLSERVER), and then click Properties.

    The SQL Server Reporting Services (MSSQLSERVER)Properties window opens

  3. Click the Log on tab.

  4. Click This account, type either NT AUTHORITY\NetworkService or a valid domain account and its password, and then click OK.

  5. Close the Services console.

See Also

Other Resources

Issues That Relate to the Application Tier for Team Foundation

Issues That Relate to SQL Server Reporting Services