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?
Sql Reporting Services服务器似乎在多个地方记录信息，包括数据库中的web服务器日志和日志记录表。SSRS记录到的所有位置在哪里，每个地方记录的错误类型是什么?
2 个解决方案
#1
19
As far as I know SSRS logs to the Event Log, the filesystem and its own database.
据我所知，SSRS记录到事件日志、文件系统和它自己的数据库。
The database is typically the most easily available one. You just login to the ReportServer database and execute
数据库通常是最容易使用的数据库。您只需登录到ReportServer数据库并执行
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 Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles
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)
如果搜索错误，可以查看Windows应用程序日志(在控制面板的管理工具下)
Edit Found a nice link:
http://msdn.microsoft.com/en-us/library/ms157403(SQL.90).aspx
编辑找到了一个不错的链接:http://msdn.microsoft.com/en-us/library/ms157403(SQL.90).aspx
#2
4
For SSRS 2008 R2: C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles
SSRS 2008 R2:C:\Program Files\Microsoft SQL Server \ MSRS10_50。MSSQLSERVER \ Reporting Services \日志
#1
19
As far as I know SSRS logs to the Event Log, the filesystem and its own database.
据我所知，SSRS记录到事件日志、文件系统和它自己的数据库。
The database is typically the most easily available one. You just login to the ReportServer database and execute
数据库通常是最容易使用的数据库。您只需登录到ReportServer数据库并执行
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 Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles
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)
如果搜索错误，可以查看Windows应用程序日志(在控制面板的管理工具下)
Edit Found a nice link:
http://msdn.microsoft.com/en-us/library/ms157403(SQL.90).aspx
编辑找到了一个不错的链接:http://msdn.microsoft.com/en-us/library/ms157403(SQL.90).aspx
#2
4
For SSRS 2008 R2: C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles
SSRS 2008 R2:C:\Program Files\Microsoft SQL Server \ MSRS10_50。MSSQLSERVER \ Reporting Services \日志