Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Reporting Services BUILTIN\Adminr, how to get rid?

Author  Topic 

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2010-04-27 : 05:54:50
Can anyone help me with a little issue (I wish it was)?

In Reporting Services 2005, it is possible to delete the BUILTIN\Administrators group and have your own admin group. This is all fine and dandy. The issue I have is that Admins can still add themselves back into the server and then carry on as normal.

I have looked everywhere for a way to stop this (don't ask about the security model at the current place i'm working, i'm likely to shoot somebody). I have thought about triggers on the backend table (Users), but the way reporting services works, it does seem to like a trigger on any of its tables checking if the user is part of builtin but not of my new admin group (IS_MEMBER()).

Does anyone have a way to totally stop access for BUILTIN? If so, please do share.

Thanks.
   

- Advertisement -