Wednesday, March 14, 2012

SSRS: Errors

SSRS makes my life unbearable.

This post for everyone who suffers with SSRS errors in SharePoint.

Here is the links that may help to identify the cause of the error:

From my experience with SSRS:

SSRS: How to troubleshoot?

SSRS and SharePoint 2007: How to configure

Simple concept: SSRS authentication

SSRS: authentication error 14 (not so smart temporary fix)

From others:

Session Timeout during execution SSRS reports

Timeouts and Microsoft SQL Server 2005 Reporting Services

Troubleshooting Server and Database Connection Problems

Reporting Services Log Files

Troubleshooting Concepts (Reporting Services)

Installing and Configuring SQL Server Reporting Services

Report Server Service Trace Log

Quick notes:

 -  The reports are slow? and SSRS log file doesn't refresh much?
 Look at the  ULS log whether the SharePoint server has an error with loading dll:
Error: Failure in loading assembly: 
Fix the error via: editing web.config file for a web application or adding the missing dll into GAC. In mycase it helped to start reports quicker.