Re: Disallow administrator access
From: Jonas Larsen (Jonas.Larsen_at_Alcan.com)
Date: 10/27/04
- Next message: Sue Hoegemeier: "Re: Disallow administrator access"
- Previous message: John Dalberg: "Re: Master database can be browsed by any user. is this normal?"
- In reply to: Todd Hazer: "Re: Disallow administrator access"
- Next in thread: Sue Hoegemeier: "Re: Disallow administrator access"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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
> >
> >
> >
- Next message: Sue Hoegemeier: "Re: Disallow administrator access"
- Previous message: John Dalberg: "Re: Master database can be browsed by any user. is this normal?"
- In reply to: Todd Hazer: "Re: Disallow administrator access"
- Next in thread: Sue Hoegemeier: "Re: Disallow administrator access"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
