Running reports - error message is generated after selecting View Report

  • An error has occurred during report processing.

    Query execution failed for data set 'DW_STD_CM25'

  • I am having the same error. I created a report and it works fine as long as someone with admin rights logs on to //server/reports. As soon as I try and run the report under an account without admin rights, i get the above error. The account does have access to the web pages. I know it has to be a permission problem, but I can't figure it out. I have created a login for the user and the group the user belongs in and neither worked.

    What else should I be looking at?

  • I figured out my problem. In the connection properties, I was using the credentials supplied by the user of the report. I changed that to the credentials stored on the report server and put in a system account with the appropriate permission for running reports.

    I also checked the box, Use as Windows credentials when connecting to data source.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply