[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 964
  • Last Modified:

SQL Server Reporting Services SSRS Report Manager is Allowing Access to All Domain Users

We are having a problem where we can't seem to restrict access to our SSRS Report Manager - at https://ourserver.com/reports.  Any user that we create inside our Active Directory can access and make changes in Report Manager.  We can correctly set permissions for the Web Service URL - https://ourserver.com/reportserver.  For instance, right now there are only two users with any access for site settings or folder settings.  There are no security groups granted permissions.

We have tried creating a new security group with no rights and then creating a new user which is only a member of this new security group.  Still, it can login and get full access to Report Manager.

We are using SSRS 2008 on Windows 2008 Server - with a Windows 2008 Active Directory.
0
w5golf
Asked:
w5golf
  • 2
1 Solution
 
lmredCommented:
I believe it may be because you need to make sure the users getting all the access are not in a role that is giving them all these permissions. Check your role assignments. Here is a SQL site with information on setting role assignments.

http://technet.microsoft.com/en-us/library/aa337385(v=sql.105).aspx
0
 
w5golfAuthor Commented:
Thanks for the thought.  As I mentioned above, the user is in a new role with no permissions.

Meanwhile, I was able to resolve this via the following post.

http://ask.sqlservercentral.com/questions/101721/ssrs-asks-for-credentials-when-entering-report-man.html
0
 
w5golfAuthor Commented:
I was able to track down the solution on another forum.
0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now