Enable SSRS Remote Errors in SharePoint Integrated Mode

Any time I have to troubleshoot issues in SQL Server Reporting Services (SSRS) reports in a production environment, I usually end up enabling Remote Errors at some point as part my process.

Remote errors are enabled via the SSRS Service Application:

  1. Navigate to Central Administration > Application Management > Manage Service Applications
  2. Next, click on the appropriate SQL Server Reporting Services Service Application service application to manage it.
  3. Click System Settings from the toolbar.
  4. Finally, enable remote errors by navigating into checking the Enable Remote Errors checkbox.

Although the MSDN documentation states that this is all that is required, I've found that I need to enable it on the individual site's settings in order to get it working:

  1. Navigate to Site Settings > Reporting Services > Reporting Services Site Settings
  2. Ensure that the Enable Local Mode Error Messages is checked.

Once the troubleshooting session is over, follow the same steps in reverse order to disable remote errors.


comments powered by Disqus