< Blog

Enabling Remote Errors in SQL

Sometimes when dealing with SSRS, you may encounter problems or errors with reports.

clip_image002

  • An error has occurred during report processing. (rsProcessingAborted)
    • Query execution failed for dataset ‘PC’. (rsErrorExecutingCommand)
      • For more information about this error navigate to the report server on the local server machine, or enable remote errors

 

How do you deal with these issues? The answer is to turn on remote error reporting.

The following TechNet article outlines how this can be done.

http://technet.microsoft.com/en-us/library/aa337165.aspx

However, I have discovered that there is a step that is missing.

Following the article’s steps, once you open SQL Management Studio and log into the Report Services instance, you will find that the Properties option is greyed out.

clip_image003

In order to make Properties available you must first run SQL Management Studio with elevated privileges. Once that is done, log into the Report Services as normal.

Upon right clicking the first node, you will see that the Properties option is now available and not greyed out. At this point you can select Properties, to bring up the Properties page.

clip_image004

Once the Properties page is open, click on Advanced. In the Advanced page look for EnableRemoteErrors. Change the value to True and click OK.

clip_image006

Now remote errors are active. The report will have more details about the actual error.

clip_image007

  • An error has occurred during report processing. (rsProcessingAborted)
    • Query execution failed for dataset ‘PC’. (rsErrorExecutingCommand)
      • Could not find stored procedure ‘MIR3_PC’.