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.

2 Answers

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.

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.

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

I hope this will help.

2

1. Connect to the database engine in SSMS and navigate to the ReportServer database.

2. Query the ConfigurationInfo table to get familiar with it. Issue the following query:

   USE ReportServer

   GO

   UPDATE ConfigurationInfo SET Value = 'True' WHERE Name = 'EnableRemoteErrors'

3. Restart Reporting Services on the server: Click Start > Administrative Tools > Services to open the Services management console. Right-click the SQL Server Reporting Services ([InstanceName]) service, and then click Restart.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.