nerdexam
Microsoft

70-466 · Question #144

You manage a SQL Server Reporting Services (SSRS) instance in SharePoint integrated mode. You identify a problem with the operations performed by the Report Server Web service. You need to view the…

The correct answer is B. %ProgramFiles%\\Common Files\\Microsoft Shared\\Web Server Extensions \\14\\Web Services \\ReportServer\\LogFiles. In SharePoint integrated mode, SSRS runs as a SharePoint shared service, so trace logs are written to the SharePoint web service extensions directory rather than the standard SQL Server Reporting Services path.

Implement a reporting services solution

Question

You manage a SQL Server Reporting Services (SSRS) instance in SharePoint integrated mode. You identify a problem with the operations performed by the Report Server Web service. You need to view the Report Server trace logs. In which directory should you view the files?

Exhibit

70-466 question #144 exhibit

Options

  • A%ProgramFiles%\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles
  • B%ProgramFiles%\Common Files\Microsoft Shared\Web Server Extensions \14\Web Services \ReportServer\LogFiles
  • C%ProgramFiles%\Common Files\ReportServer\LogFiles
  • D%ProgramFiles%\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\LogFiles

How the community answered

(17 responses)
  • B
    94% (16)
  • D
    6% (1)

Why each option

In SharePoint integrated mode, SSRS runs as a SharePoint shared service, so trace logs are written to the SharePoint web service extensions directory rather than the standard SQL Server Reporting Services path.

A%ProgramFiles%\\Microsoft SQL Server\\MSRS10_50.MSSQLSERVER\\Reporting Services\\LogFiles

This path (MSRS10_50.MSSQLSERVER) is the log directory for SSRS 2008 R2 running in native mode, not SharePoint integrated mode.

B%ProgramFiles%\\Common Files\\Microsoft Shared\\Web Server Extensions \\14\\Web Services \\ReportServer\\LogFilesCorrect

When SSRS is configured in SharePoint integrated mode, the Report Server Web service operates under SharePoint's infrastructure. Trace logs are written to the SharePoint 14 hive path at %ProgramFiles%\Common Files\Microsoft Shared\Web Server Extensions\14\Web Services\ReportServer\LogFiles, not the standalone Reporting Services path. This is because the web service endpoints are hosted by SharePoint, making the log output location distinct from native mode installations.

C%ProgramFiles%\\Common Files\\ReportServer\\LogFiles

This path does not correspond to any standard SSRS installation directory and would not contain Report Server trace logs.

D%ProgramFiles%\\Microsoft SQL Server\\MSRS11.MSSQLSERVER\\Reporting Services\\LogFiles

This path (MSRS11.MSSQLSERVER) is the log directory for SSRS 2012 in native mode, and does not apply when SSRS is running in SharePoint integrated mode.

Concept tested: SSRS SharePoint integrated mode trace log location

Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-server/report-server-service-trace-log

Topics

#SSRS#SharePoint integrated mode#trace logs#log file location

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice