?
Solved

Security issue Reporting Services 2005  (Everyone has administrative priviledges). How do I remove it?

Posted on 2008-10-06
4
Medium Priority
?
546 Views
Last Modified: 2008-11-18
I installed Reporting Services 2005 on a PC with Windows Server 2003 (Standard Edition) SP2.
However, every user within the Company Active Directory has access to the site, even though I have not grant then access through the application.
-  I checked in "Site Settings > Configure site-wide security" and only Administrators and myself have access to it.
- I checked in the "Home > Properties > Security", and only one user has access ( my end user ).

Still everyone can see the web page as if they had Administrative priviledges. What am I missing here?
0
Comment
Question by:hispanicteleservices
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 6

Expert Comment

by:kavlins
ID: 22652916
Login to SQL Server through management studio

1. Open the "SQL Server Enterprise Manager". This is usually under "Start"-->"Programs"-->"Microsoft SQL Server".

2. Navigate to the "Logins" object under the "Security" folder on the SQL Server you wish to administer. Then, right click on the 'sa' account and select "Properties".

3. Now do whatever you need to do...

0
 

Author Comment

by:hispanicteleservices
ID: 22654355
Thanks for the respose (I really mean it).
I already did that, but "sa" seems to be configured correctly (as system admin).
Also
  • I removed any user Account that does not need to be there.
  • Removed all non-required administrator access.
  • Removed any permission not required by ReportingServices databases.
Still, everyone has admin access to the site. Also, i found out that if a remove "Administrators" from the Site, everyone has limited access to administration, but if i add it, everyone has full access to administration.
By the way, Windows Service Identity is currently running as NetworkService.
Any ideas?
0
 

Accepted Solution

by:
hispanicteleservices earned 0 total points
ID: 22950842
I reinstalled Reporting Services from scratch.
I must have messed up with the security roles somewhere and this was the only way to fix it.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question