Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

What to do when error "For more information about this error navigate to the report server " Expand / Collapse
Author
Message
Posted Thursday, March 4, 2010 6:30 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, July 27, 2014 8:47 PM
Points: 316, Visits: 1,483
I'm getting an error for a report that I created in BIDS. Everything works fine in SQL and in BIDS, but not in SSRS 2005 report manager. I'm setup as an admin on the report server, so I have super-duper powers.

Unfortunately, I'm receiving the following error:

An error has occurred during report processing.
Query execution failed for data set 'DataSet1'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors


What does the last sentence mean? What should be looked at after navigating to the report server?



Post #876793
Posted Wednesday, March 10, 2010 12:50 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 17, 2014 12:34 PM
Points: 1,414, Visits: 4,539
have you tried to run the report while RDP'd on the Report Server? there is a setting in SSRS to forward the error to the host but i forgot where it is. accessing the report via BIDS or IE on the server will report the real error

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #880500
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse