Solved

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

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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

626 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