Where are all the places Sql Reporting Server Logs Errors?
Where are all the places Sql Reporting Server Logs Errors?
It seems like Sql Reporting Services Server logs information in several places including web server logs and logging tables in the database. Where are all the locations SSRS logs to, and what type of errors are logged in each place?
2 Answers
2
As far as I know SSRS logs to the Event Log, the filesystem and its own database.
The database is typically the most easily available one. You just login to the ReportServer database and execute
select * from executionlog
This only logs the executions though. If you want more information you can go to the Trace Log files, which are usually available at (location may of course vary):
C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles
These are quite verbose and not really fun to look through. But they do log a lot of stuff.
If you're searching for an error you can go to the Windows Application Log (Under Administrative Tools in your control panel)
Edit Found a nice link:
https://docs.microsoft.com/en-us/sql/reporting-services/report-server/reporting-services-log-files-and-sources
For SSRS 2008 R2:
C:Program FilesMicrosoft SQL ServerMSRS10_50.MSSQLSERVERReporting ServicesLogFiles
Thanks for contributing an answer to Stack Overflow!
But avoid …
To learn more, see our tips on writing great answers.
Required, but never shown
Required, but never shown
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
