Sql-server – “Enable remote error” in SSRS

reporting-servicessql server

When I compile a report in SSRS, an common error occurred as shown.
I may probably "Enable remote error" in Reporting Services server to fix the report connection in SSRS.
But:
What is the impact of doing that? Will it affect existing production jobs?

Thank you very much.

enter image description here

Best Answer

Follow below procedure to enable remote error in SSRS

1) Open SQL Server Management studio and log in with reporting services as the service type.

enter image description here

2) right click on the instance and go to properties so here attach an image as the popup is shown after goto Advanced tab here you can find EnableRemoteError in Security tree.

enter image description here

After enabling remote error you can figure out actual error thrown by the database.

I hope this will help.