Loading

An error has occurred during report processing - SSRS

Thiyagarajan E

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'.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Thiyagarajan E10y ago
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 to be set to windows

// identity impersonate to be set to true and User name & Password of the SQL Server administrator should be added.
+1