<div>
for domain joined computers, doesnt builtin\administrators also include domain admins domain group?
</div>


for domain joined computers, doesnt builtin\administrators also include domain admins domain group?

<div>
Yes, it includes the local Administrator and the &quot;DOMAIN\Domain Admins&quot; group.
</div>


Yes, it includes the local Administrator and the "DOMAIN\Domain Admins" group.

<div>
Is it common for places just to grant DBA's sysadmins, and general server admins have no need to be sysadmins?
</div>


Is it common for places just to grant DBA's sysadmins, and general server admins have no need to be sysadmins?

<div>
Usually, general server admins don't need to be SQL's sysadmins because they are 2 different roles which require different knowledge and vice-versa.
</div>


Usually, general server admins don't need to be SQL's sysadmins because they are 2 different roles which require different knowledge and vice-versa.

<div>
<div class="content wysiwyg-content">
Can anyone give me a managers (idiots) guide on the overal risk by adding the builtin\administrators group the sysadmin role in MSSQL?<br />
<br />
Whats the risk?<br />
<br />
And do you configure your MSSQL Servers so that BUILTIN\admins are not memebers of the sysadmin role? <br />
<br />
Does not having BUILTIN\admins as memebers of the sysadmin role cause any issues in managing systems?
</div>
</div>


Can anyone give me a managers (idiots) guide on the overal risk by adding the builtin\administrators group the sysadmin role in MSSQL?

Whats the risk?

And do you configure your MSSQL Servers so that BUILTIN\admins are not memebers of the sysadmin role? 

Does not having BUILTIN\admins as memebers of the sysadmin role cause any issues in managing systems?

builtin\administrators part of sysadmin role

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.