Link to home
Start Free TrialLog in
Avatar of StampIT
StampITFlag for United States of America

asked on

SSRS Enable Remote Errors

I created an SSRS report that executes fine in Microsoft Visual Studio. I deployed it to the report server. However when I try to execute from the report server I get the following:

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

How do I enable remote errors ? Or is there another method of determining what is causing this error ?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Jason clark
Jason clark
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Vikas Garg
Hi,
The error might be due to the report unable to access the dataset. If it is a shared dataset please check the credentials. If it is report specific dataset check the same in VS also.
Avatar of StampIT

ASKER

Thanks. Enabling remote error reporting identified the error. It is:
"The EXECUTE permission was denied on the object 'ds_HundConv_2', database 'Test', schema 'tst'."
ds_HundConv_2 is a function. Do you know what that issue might be ?

Thanks.
HI,

The user does not have Stored Procedure execute permission on the mentioned database and schema