SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 SSRS Security
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SunnyDee
Yak Posting Veteran

76 Posts

Posted - 04/25/2013 :  09:00:20  Show Profile  Reply with Quote
Good morning,

I have followed the instructions for setting up user security but have had many issues. Using the Site Settings --> Security, I have set up users and groups with the role of 'System User'. It is my understanding that this gives them access to the SSRS site as whole, correct?

Users can access the site, but get the error message RSAccess denied when attempting to run reports. I have set up the authentication to be windows based. I also have reports set up with SQL authentication. I get the same error message in both cases.

I have given users folder level security with the role browser and my reports. This error message can only be resolved by giving the users access to the data set. Is this the normal behavior? In everything I have read about security, it does not mention that I need to give access to the data set to the users. I'm wondering if there is something wrong with either the SSRS server set up or user authentication to the database.

Note: If I store the credentials of the data source securely in the server (using a super user and password that has access to all tables and views in the database), I am still getting this message. The only thing that seems to give the users access is at the dataset level. Is this normal SSRS Security behavior?

Many thanks

SunnyDee
Yak Posting Veteran

76 Posts

Posted - 07/25/2013 :  13:50:00  Show Profile  Reply with Quote
I am having the same issue. The only way users can run reports is to give them access at the dataset level. THis does not seem to match the documentation.
Go to Top of Page

SunnyDee
Yak Posting Veteran

76 Posts

Posted - 09/12/2013 :  16:27:17  Show Profile  Reply with Quote
Is anyone else having this issue? I am not understanding why I need to give users access to the dataset when they have access to the report already?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000