Monday, March 12, 2012

how to find out who are in BUILTIN/Administrators Group?

sql2k, nt5
Does anyone know how to find out who are the members in
BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
admin group and can't see nt account info from the NT side).
thank you.The BUILTIN/Administrators group maps to the Windows Local administrators
group. If you can't see who's in the Windows group, you can't find out who's
in BUILTIN/Administrators.
--
Jacco Schalkwijk
SQL Server MVP
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:%23W8uAl7JEHA.3980@.TK2MSFTNGP10.phx.gbl...
> sql2k, nt5
> Does anyone know how to find out who are the members in
> BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
> admin group and can't see nt account info from the NT side).
> thank you.
>|||You can try
exec master..xp_logininfo 'BUILTIN\Administrators','members'
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:%23W8uAl7JEHA.3980@.TK2MSFTNGP10.phx.gbl...
> sql2k, nt5
> Does anyone know how to find out who are the members in
> BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
> admin group and can't see nt account info from the NT side).
> thank you.
>|||that's very helpful. thank you!!!
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:ObGoTa8JEHA.644@.tk2msftngp13.phx.gbl...
> You can try
> exec master..xp_logininfo 'BUILTIN\Administrators','members'
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> news:%23W8uAl7JEHA.3980@.TK2MSFTNGP10.phx.gbl...
> > sql2k, nt5
> >
> > Does anyone know how to find out who are the members in
> > BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
> > admin group and can't see nt account info from the NT side).
> >
> > thank you.
> >
> >
>

No comments:

Post a Comment