Microsoft P2P Reporting Reports Error | 2pint Knowledge Base

Microsoft P2P Reporting Reports Error

 

Applies to

Microsoft P2P Reporting

Symptoms

Microsoft P2P Reporting Reports have been imported into your SQL reporting environment but when running Reports the following errors are seen

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

Cause

In this instance Reporting service account did not have Select permissions on the DB

Solution

Grant the Reporting Service account the appropriate permissions to the DB