Turn on Reporting Services events for the SharePoint trace log (ULS)
Starting with SQL Server 2008 R2, Reporting Services servers in SharePoint mode can write Reporting Services events to the SharePoint Unified Logging Service (ULS) trace log. Reporting Services specific categories are available on the Monitoring page of SharePoint Central Administration.
In this Topic:
The following table lists event categories and levels that are recommended for monitoring a Reporting Services environment.. When an event is logged, each entry includes the time the event was logged, the process name, and the thread ID.
Logs events that involve database access.
Logs events that involve access to the following items:
Office Server General
Logs logon failures.
Logs current user information.
Logs events that involve access to the Report Viewer Web Part.
To turn on and off Reporting Services events in the Reporting Services Category
From SharePoint Central Administration
Click Configure Diagnostic Logging in the Reporting group.
Find SQL Server Reporting Services in the category list.
Click the plus symbol (+) to expand the sub categories under SQL Server Reporting Services.
Select the subcategories to be added to the trace log.
At the bottom of the categories list, select an event level for the Least critical event to report to the trace log. Select None to disable tracing.
The option Least critical event to report to the event log is not supported by Reporting Services. The option is ignored.
The following logging options are recommended as a standard configuration:
SOAP Client Proxy
If you are experiencing issues with configuration, add Configuration Pages.
You can review all of the current farm diagnostic log settings with the following PowerShell cmdlet:
The Reporting Services entries in the log are formatted in the following way.
Product: SQL Server Reporting Services
Category: Events related to the server will have the characters “Report Server”, at the beginning of the name. For example “Report Server Alerting Runtime” These events are also logged to the report server log files.
Category: Events related to or communicated from a web front-end component do not contain “Report Server”. For example “Service Application Proxy” Report Server Alerting Runtime”. The WFE entries do contain a CorrelationID but the server entries do not.
The following table is a list of the events in the SQL Server Reporting Services Category:
Description or sample entries
Local Mode Processing
Local Mode Rendering
SOAP Client Proxy
Log entries that were written to the LogClientTraceEvents API. These entries are sourced from client applications, including Power View, a feature of SQL Server 2016 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition.
All log entries from the LogClientTraceEvents API will be logged under the Category of “SQL Server Reporting Services” and the Area of “Power View”.
The content of entries logged with the area of “Power View” is determined by the client application.
Report Server Alerting Runtime
Report Server App Domain Manager
Report Server Buffered Response
Report Server Cache
Report Server Catalog
Report Server Chunk
Report Server Cleanup
Report Server Configuration Manager
MediumUsing report server internal url http://localhost:80/ReportServer.
UnexpectedMissing or Invalid ExtendedProtectionLevel setting
Report Server Crypto
Report Server Data Extension
Report Server DB Polling
Report Server Default
Report Server Email Extension
Report Server Excel Renderer
Report Server Extension Factory
Report Server HTTP Runtime
Report Server Image Renderer
Report Server Memory Monitoring
Report Server Notification
Report Server Processing
Report Server Provider
Report Server Rendering
Report Server Report Preview
Report Server Resource Utility
MediumReporting Services starting SKU: Evaluation
MediumEvaluation copy: 180 days left
Report Server Running Jobs
Report Server Running Requests
Report Server Schedule
Report Server Security
Report Server Service Controller
Report Server Session
Report Server Subscription
Report Server WCF Runtime
Report Server Web Server
Service Application Proxy
MediumGranting access to content databases.
MediumProvisioning instances for ReportingWebServiceApplication
MediumProcessing service account change for ReportingWebServiceApplication
MediumSetting database permissions.
You can use PowerShell to return a list of the Reporting Services related events from a ULS Log file. Type the following command from the SharePoint 2010 Management Shell to return a filtered list of rows from the file a ULS log file UESQL11SPOINT-20110606-1530.log, that contain “sql server reporting services”:
Get-content -path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS\UESQL11SPOINT-20110606-1530.log" | select-string "sql server reporting services”
For more information on how to use PowerShell to view log data, see View diagnostic logs (SharePoint Server 2010)
The Trace Log files are usually found in the folder c:\Program Files\Common files\Microsoft Shared\Web Server Extensions\14\logs but you can verify or change the path from the Diagnostic Logging page in SharePoint Central Administration.
For more information and steps to configure diagnostic logging on a SharePoint server in SharePoint 2010 Central Administration, see Configure diagnostic logging settings (Windows SharePoint Services).