Question about Local Administrator and SQL Server 1

[pandatime]

Hi,

If I am a member of the Local Administrators group on a server, then which login in SQL Server do I belong to? Builtin\Administrators or NT Authority\System? How can I tell?

Thanks much

 

[mrdenny]

If you are a member of the Administrators group then you are in BUILTIN\Administrators. NT Authority\System is the local system account.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog