Wednesday, March 21, 2012

Problem getting some users to be able to run reports (probably security of some sort)

I am able to deploy and run reports from my screen at work, but some non-developers cannot run them. They can see the reports, but get the following error message when they click on the report:

  • An error has occurred during report processing. (rsProcessingAborted)

  • Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)

  • For more information about this error navigate to the report server on the local server machine, or enable remote errors

  • --

  • --

  • - I assume the preceding error has something to do with credentials. I am using Windows security authentication for this. One user has worked through this and is now getting cannot run report query (one of the report queries in the report). Help would be appreciated.

  • Can you make sure that the users who are having issues can actually connect to the SQL Server & database?

    Have you tried running Profiler to see what credentials are actually passed to the SQL Server when the user runs the report?

    Jarret

    |||What was found was a security issue. I got some DBA help in setting up permissions to login to the database and to grant run permissions on the queries. First access was granted to the database itself, the we had to go into security on the database and setup the user and grant permissions. This resolved the problem.
  • No comments:

    Post a Comment