Grant users rights to run reports on reporting services

45 pts.
Tags:
Reporting Services 2005
SQL 2005
How do I grant users rights to run reports on reporting services?  Those with admin access can run them, but users without admin access can't - they get an error that they don't have access to the data source.  When setting up the source, we used windows authentication.  I've given clearance on the website itself and in management studio I gave the user public clearance and added her to the RSExecRole.  She still gets the same error messages.  I can't find any specific spot to grant access to the data sources themselves.

Software/Hardware used:
Sql 2005 Reporting Services

Answer Wiki

Thanks. We'll let you know when a new response is added.

What roles has the user been given within the Folder that the reports are in?

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Cindyfiller
    Under site settings / system role assignments I've added this user as a system user. That role has the following rights: execute report definitions, view report server properties, view shared schedules. All of the other options have to do with Managing and I didn't feel she needed those rights.
    45 pointsBadges:
    report
  • Cindyfiller
    Sorry for the delay in answering this. I was out of town. I did find the spot that I had missed. In management studio I hadn't give users the dbreader role. That seemed to take care of this issue. But I have one report that I'm still having problems with. There is a data set created within that report and now users can't run this because of a security issue with the dataset. They can run other reports, but not this one.
    45 pointsBadges:
    report
  • Denny Cherry
    Log into the SQL Server using one of the users accounts and run the query manually. This should tell you where the problem is coming from. Or turn on remote errors in the web.config for the report server.
    66,185 pointsBadges:
    report
  • Cindyfiller
    Sorry for the delay in responding. I did find the issue on this. I have give them public access, but needed to give the users dbread access against the data warehouse. Users can run all reports except for one. That one has a stored procedure and users are getting an error message that they don't have access to the dataset created from the stored procedure. I've gone through and given them the same rights as the data warehouse on the stored procedure, but so far that hasn't worked.
    45 pointsBadges:
    report
  • Denny Cherry
    You will need to give the users the right to run the stored procedure.
    GRANT EXEC ON YourStoredProcedure TO YourUserOrRole
    66,185 pointsBadges:
    report
  • Cindyfiller
    I use the GUI interface in management studio. I did give execute access to this user and it still didn't work. I opened up the stored procedure and noticed that it was creating another view in the procedure. While the view was in the data warehouse that the user had access to, I did go in and give specific rights to that view also. But the user still gets the same error. I have no clue what to try now.
    45 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following