Solved

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

Posted on 2008-10-06
4
541 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
  • 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

Suggested Solutions

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

830 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