BUILTIN\Administrators Account

Hi all,
I'm running sql server 2000. I'm wondering if I can
remove the BUILTIN\Administors in sql server. Would it
cause any problem to sql server? is ther anything running
behind sql server using this account?
Thanks,
ttThere should be no problem, as long as you are use either the 'sa' account
or have created other administrative account directly in SQL.
BUILTIN\Administers group will give any administrative login account (on the
computer) full admin rights to SQL Server. So as long as you don't want any
joe-blow admin messing with your SQL Server, remove it.
my two cents and yes, my name really is Joe.
"tt" <anonymous@.discussions.microsoft.com> wrote in message
news:2aab201c465f3$63e81930$a301280a@.phx
.gbl...
> Hi all,
> I'm running sql server 2000. I'm wondering if I can
> remove the BUILTIN\Administors in sql server. Would it
> cause any problem to sql server? is ther anything running
> behind sql server using this account?
> Thanks,
> tt|||You'll want to specify another group as SQL system Admins prior to dropping
this group.
263712 INF: How to impede Windows NT administrators from administering a
http://support.microsoft.com/?id=263712
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||We've removed the builtin group from all our production servers without any
issues and as referred ensure your login or referred logins has required pr
ivileges in order to hand SQL Server.
--
--
Satya SKJ
"Kevin McDonnell [MSFT]" wrote:

> You'll want to specify another group as SQL system Admins prior to droppin
g
> this group.
> 263712 INF: How to impede Windows NT administrators from administering a
> http://support.microsoft.com/?id=263712
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>|||Hello,
I would like to remove sysadmin privleges on the "BUILTIN\Administrators" gr
oup on my SQL Server...but before I do - I have a question:
If I remove sysadmin privleges and am not happy w/ how this affects my serve
r - is there an easy way to put my system back to the way it was? I'd imagin
e that if all I did was remove it from sysadmin in EM then all I have to do
is grant sysadmin back agai
n. Is this correct?
I'd appreciate any feedback...
Thanks!
John
"Satya SKJ" wrote:
[vbcol=seagreen]
> We've removed the builtin group from all our production servers without an
y issues and as referred ensure your login or referred logins has required
privileges in order to hand SQL Server.
> --
> --
> Satya SKJ
>
> "Kevin McDonnell [MSFT]" wrote:
>|||You can execute the following in Query Analyzer:
EXEC sp_grantlogin 'BUILTIN\Administrators'
By default, the group is a member of the sysadmins sql
server role. If you wanted this back as well, you could
execute the following:
EXEC sp_addsrvrolemember 'BUILTIN\Administrators' ,
'sysadmin'
-Sue
On Mon, 2 Aug 2004 10:19:02 -0700, John P
<JohnP@.discussions.microsoft.com> wrote:

>Hello,
>I would like to remove sysadmin privleges on the "BUILTIN\Administrators" g
roup on my SQL Server...but before I do - I have a question:
>If I remove sysadmin privleges and am not happy w/ how this affects my server - is
there an easy way to put my system back to the way it was? I'd imagine that if all I
did was remove it from sysadmin in EM then all I have to do is grant sysadmin back
aga
in. Is this correct?[vbcol=seagreen]
>I'd appreciate any feedback...
>Thanks!
>John
>"Satya SKJ" wrote:
>