Improve company productivity with a Business Account.Sign Up

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

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?
0
hispanicteleservices
Asked:
hispanicteleservices
  • 2
1 Solution
 
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
 
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
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.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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