Enable Remote Errors in SQL Server Reporting Services 2005

Reporting Services 2005

Enabling remote errors in SQL Server Reporting Services 2005 (SSRS)

By default, reporting services returns the following error message when a report produces an error:

An error has occurred during report processing.
Cannot create a connection to data source 'AdventureWorks'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors.

Its inconvenient and sometimes not possible to have to browse the page on the local server. In a development environment it would be better to enable remote errors.

To enable remote errors in SSRS create a .rss script ( a plain text file ) with the following contents:

Public Sub Main()
     Dim P As New [Property]()
     P.Name = "EnableRemoteErrors"
     P.Value = True
     Dim Properties(0) As [Property]
     Properties(0) = P
     Try
         rs.SetSystemProperties(Properties)
         Console.WriteLine("Remote errors enabled.")
     Catch SE As SoapException
         Console.WriteLine(SE.Detail.OuterXml)
     End Try
End Sub

Then run the script using the rs.exe utility that is installed with Reporting Services:

rs -i ssrs2005-enable-remote-errors.rss -s http://localhost/ReportServer

You can download the ssrs2005-enable-remote-errors.rss script here

Thanks to Robert Bruckner for the script.



Share
  • Facebook
  • Google Bookmarks
  • Ask
  • LinkedIn
  • Socialogs
  • Wikio
  • Digg
  • Twitter
  • SlashDot
  • Reddit
  • MySpace
  • Del.icio.us
  • Blogter
  • BlogMemes
  • Yahoo Buzz






Enable Remote Errors in SQL Server Reporting Services 2005 | 0 comments | Create New Account
The following comments are owned by whomever posted them. This site is not responsible for what they say.


Gold Coast Aquarium Maintenance | Gold Coast Marine Fish | Gold Coast Tropical Fish
Jewel Jones - Counselling Service - Penrith, Richmond
 
     
 Copyright © 2017 Julian Kuiters
 All trademarks and copyrights on this page are owned by their respective owners.