Grant users rights to run reports on reporting services
Home > IT Answers > SQL Server > Grant users rights to run reports on reportin...
Cindyfiller
45 pts.
0
Q:
Grant users rights to run reports on reporting services
SQL 2005, Reporting Services 2005, Microsoft SQL Reporting Services
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
ASKED: Oct 19 2009  3:10 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46765 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
What roles has the user been given within the Folder that the reports are in?
Last Answered: Oct 19 2009  6:50 PM GMT by Mrdenny   46765 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Cindyfiller   45 pts.  |   Oct 19 2009  9:37PM GMT

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.

 

Cindyfiller   45 pts.  |   Nov 2 2009  8:08PM GMT

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.

 

mrdenny   46765 pts.  |   Nov 10 2009  12:48AM GMT

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.

 

Cindyfiller   45 pts.  |   Nov 16 2009  2:21PM GMT

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.

 

Mrdenny   46765 pts.  |   Nov 17 2009  8:57PM GMT

You will need to give the users the right to run the stored procedure.

GRANT EXEC ON YourStoredProcedure TO YourUserOrRole

 

Cindyfiller   45 pts.  |   Nov 18 2009  10:41PM GMT

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.

 
0