StampIT
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
"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
The user does not have Stored Procedure execute permission on the mentioned database and schema
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.