An error has occurred during report processing - SSRS

Question

 An error has occurred during report processing in SSRS Report.

 

 I am getting the error when view the SSRS report in browser. 

 

The report viewer works fine for the SQL Administrator login.

When users other than SQL administrator try to access SSRS reports, the following error arises

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source ' DataSource1'. (rsErrorOpeningConnection)

Login failed for user 'SERVER\UserName'.

 

 

 

 

Answer 1

I found the Solution:

Finf the Report web config in the below path :

C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportManager\web .config

Replace or add below line: to set admin credential for all users to access the report.

<authentication mode="Windows" /> // Authentication mode to be set to windows

<identity impersonate="true " userName="UserName" password="Password"/> // identity impersonate to be set to true and User name & Password of the SQL Server administrator should be added.