Re: Builtin\Administrators

From: Wayne Snyder (wsnyder@computeredservices.com)
Date: 10/15/02


From: "Wayne Snyder" <wsnyder@computeredservices.com>
Date: Tue, 15 Oct 2002 14:49:56 -0700


No problem, just make sure you have added an NT login for YOU to use and
made it part of the sysadministrators role.

"Mike Mullane" <Mike.Mullane@hpinc.com> wrote in message
news:2e6d01c27477$a0f9c950$37ef2ecf@TKMSFTNGXA13...
> SQL Server 2000, SP2
> Windows 2000, SP3
>
> The public group by default has no object rights and guest
> accounts have been deleted from "userdatabases"..sysusers.
> But the group Builtin\administrators is still giving me
> problems trying to block out certain privileged Windows
> accounts.
>
> By removing Builtin\administrators from the fixed server
> role System Administrators, will this cause me any issues?
>
> Thanks in advance.
>
> Mike
>



Relevant Pages

  • BuiltinAdministrators
    ... SQL Server 2000, SP2 ... Windows 2000, SP3 ... The public group by default has no object rights and guest ... accounts have been deleted from "userdatabases"..sysusers. ...
    (microsoft.public.sqlserver.security)
  • Re: BuiltinAdministrators
    ... >SQL Server 2000, SP2 ... >The public group by default has no object rights and guest ... >accounts have been deleted from "userdatabases"..sysusers. ...
    (microsoft.public.sqlserver.security)
  • Re: BuiltinAdministrators
    ... On windows 2000 you can get round ... > SQL Server 2000, SP2 ... > The public group by default has no object rights and guest ... > accounts have been deleted from "userdatabases"..sysusers. ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie question on SQL connection
    ... > Let me educate you about SQL Server security. ... granting permissions to these accounts in SQL ... > maintain its own user accounts, which are separate from domain user ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Sql server 2005 clustered service group
    ... For each clustered service in the instance of SQL Server that you are ... administrator for the names of existing domain groups, ... Note that SQL Server accounts will not be removed from the groups if SQL ... I see with installing SS2005 cluster if forces me to use domain accounts ...
    (microsoft.public.sqlserver.setup)

Quantcast