Re: Disallow administrator access

From: Jonas Larsen (Jonas.Larsen_at_Alcan.com)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 10:11:47 +1000

Remove the builtin\Administrators from the SQL Server instead of deny. And
the add you own domain account as system admin in SQL.

Jonas
"Todd Hazer" <NO_SPAMthazer@gmail.com> wrote in message
news:%23JM86O7uEHA.3276@TK2MSFTNGP15.phx.gbl...
> 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

  • Re: Linked Server Connection Error: 18459
    ... Did either of your SQL Server instances run under a domain user account? ... I recommend that you first ensure that your SQL Server ...
    (microsoft.public.sqlserver.connect)
  • Re: Windows authentication/impersonation.. login failed for user null?
    ... You must make sure that domain user account or the domain security group ... ia mapped to a SQL server login/Sql Server ... database user. ... and then make specific SQL Server login as ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Windows authentication/impersonation.. login failed for user null?
    ... You must make sure that domain user account or the domain security group ... ia mapped to a SQL server login/Sql Server ... database user. ... and then make specific SQL Server login as ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: MSSQLServer Service Account
    ... Access and change the SQL Server directory (\Program Files\Microsoft SQL ... a domain user account must be able to read and write ... Member of local Power Users or local Administrators group ... > in order to be able to access the remote server. ...
    (microsoft.public.sqlserver.security)