February 9, 2007 at 1:34 pm
I have a need to restrict all users in this group from access to any database in an instance. What's the best why and how are rest of you managing this admin group?
February 9, 2007 at 2:00 pm
I remove BUILTIN\Administrators from the SQL Server.
Make sure you add your own login to SQL first, however.
February 9, 2007 at 2:14 pm
Thanks
That's what I will do. I've drawing a blank but if the group is DBO you need to untangle all the dbo connections what's the script to do remove dbo from the group?
February 9, 2007 at 4:04 pm
Before deleting the builtin\Administrators group, be sure you have at least 2 if not 3 alternative ways to login to your SQL Server instance with sys admin privledges, and that these logins are known by only those who really need to know.
February 9, 2007 at 4:24 pm
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply