Question:
A report is failing. How do I see the actual error without having to run the report on the server?
Answer:
In SQL 2008 or later this is fairly simple.
- Use SQL Management Studio Object Browser and connect to the report server (not the database engine!)
- Once connected, right click on the Report Server name and chose Properties.
- Choose the Advanced tab.
- Scroll down and find EnableRemoteErrors
- Set to True and apply.
When you next run the report, you should receive a far more verbose message.
Official Warning: the full remote error may reveal information about the internal structure of your database or your network, so Microsoft‘s official recommendation is to disable the remote error feature when not actively troubleshooting. We also strongly advise against using ‘password‘ as your password.
Additional Comments:
See Microsoft Instructions –http://technet.microsoft.com/en-us/library/aa337165.aspx
KBA-01480; Last updated: October 13, 2016 at 8:00 am;
Keywords: SSRS remote error messages