Debugging Reports in Reporting Services

You may have a problem running an SSRS report and get the following error “For more information about this error, navigate to the report server on the local server machine, or enable remote errors”. Now chances are if it is a production report server you wont have machine access to run the report as a local administrator. So the only other option is to enable remote errors. How do you do that? Simple! Download this file and then from a command prompt enter the following;

rs -i EnableRemoteErrors.rss -s http://servername/ReportServer

Now when you run the report you should get detailed enough information to allow you to find the problem.