Removing Administrators access to all folders

Hot Topic

Correct syntax for dtsrun
Bug in SQL Server 2005 ? - DATEADD function
Cannot install Microsoft SQL Server 2005 Express Edition x86
DB Objects stored in VSS
How to script all sql jobs
Log Shipping from SQL Server 2000 to SQL Server 2005
Creating tables from other tables
job keep running if fail
Encrypted DB -- Restore Question
How to iterate over a recordset?

SQL Server

Conditional calculated member
Unable to open Local Cube in Excel
How to 'attach' an existing .MDF file to the local SQL Server
Creating a double entry book keeping system
CopyDataBase from MSSQL2000 to MSSQL2005 + Identity Specification
NS 2.0 and SQL Server 2005?
Help
how do I use the crosstab query in sql server mobile edition
SQL Server 2005 Installation does not install sqldmo.dll
Task execution order

Removing Administrators access to all folders

We would like to not allow our administrators to see sensitive Payroll information in Reporting Services. I have removed 'BUILTIN\Administrators' from all folders, yet those in the Domain Admins group can still see all of the adminstrative functions, as well as all of the folders. We don't want them to see some of the folders.

Does this have to do with the Domain Admins having local Admin rights on the server



Answer this question

Removing Administrators access to all folders

  • DJT_UK

    Can we take Domain Administrator's out of the Local Administrators group on the server and get the same effect

  • delimavi

    Domain administrators are the superpowerful users, I dont think you can deny access to them

  • Buddhaaz

    I think you have to install RS with another service, not Local Service or Networkservice, you can make the service to be installed to the name of a special user Financee\FinanceeAdministrator, after it remove builtin\administrators on the folders you dont want them to see,



  • Removing Administrators access to all folders
Answer this question