Re: Disallow administrator access

From: Todd Hazer (NO_SPAMthazer_at_gmail.com)
Date: 10/27/04 

Date: Tue, 26 Oct 2004 16:33:15 -0700

I have added my domain user account to the security logins and set
myself up as a system administrator. My domain user account is in the
domain Administrators group and in the Domain Admins group.

I just set the SQL Server builtin\Administrators security access setting
to "Deny" and it stopped me from connecting as well. How can I disallow
one administrator without denying myself?

Todd

Jonas Larsen wrote:
> Remove the builtin\Administrators from the Security - login in SQL server.
>
> Regards
> Jonas
> "Todd Hazer" <NO_SPAMthazer@gmail.com> wrote in message
> news:%231Tl8k6uEHA.2876@TK2MSFTNGP12.phx.gbl...
>
>>Can anyone tell me how I can stop a domain administrator from accessing
>>SQL Server 2000 on Windows 2003 Server.
>>
>>Todd
>
>
>

Relevant Pages