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

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?
hispanicteleservicesAsked:
Who is Participating?
 
hispanicteleservicesAuthor Commented:
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
 
kavlinsCommented:
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
 
hispanicteleservicesAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.