Wednesday, February 29, 2012

SSRS: How to troubleshoot?



Got weird errors on SSRS?: 
such as below:

  • An error occurred during client rendering.
    • Too many automatic redirections were attempted. 

The good place to start is:

1.

SSRS logs

C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles
(assuming that you have C:\ as a system drive)
2.
Find error and google it.

P.S.
In case you have found this post by searching:

  • An error occurred during client rendering.
    • Too many automatic redirections were attempted. 
You may have problem with HTTPS communication.

Check the config file for SSRS:

C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config

If you need to have HTTP connection: set


<Add Key="SecureConnectionLevel" Value="0"/> instead of 2