This project has moved. For the latest updates, please go here.

Previous Configure Standard Accounts Manual Configuration Configure DBA Non-Sysadmin Group Next

Configure Sysadmin Accounts

FineBuild can configure the Sysadmin accounts that are needed by SQL Server.

Details of the accounts that are given sysadmin rights are given below:
Description
Account that is running the SQL FineBuild install process
DBA Team Sysadmin group
SQL Server Service account
SQL Agent Service account

Security Compliance

Sysadmin Accounts configuration helps to focus SQL DB Engine administration rights on to the DBA Team. If you setup Security Compliance then Sysadmin Accounts configuration will always be implemented.

FineBuild Configure Sysadmin Accounts

The Sysadmin Accounts configuration relates to Process Id 5CB and is controlled by the parameters below:

Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupSAAccounts FULL Yes Yes Yes Yes
SetupSAAccounts WORKSTATION Yes Yes Yes Yes
SetupSAAccounts CLIENT N/A N/A N/A N/A

In order to maintain compatibility with older versions of SQL FineBuild, the parameter ConfigSAAccounts can also be used.

FineBuild also uses the following parameters to help Configure Sysadmin Accounts:
Parameter Default Value Description
GroupDBA GBGGDBAS01 DBA Team Sysadmin group
SQLSvcAccount none SQL Server Service account
AgtSvcAccount none SQL Agent Service account

FineBuild will automatically give these accounts sysadmin rights in SQL Server.
Top

Manual Configure Sysadmin Accounts

The following steps show what you would have to do for manual Sysadmin Accounts configuration. FineBuild does all of this work for you automatically.

The same process is used to configure all of these accounts. When the accounts are added to SQL Server in Configure Standard Accounts, the following additional step should also be performed.

1) Set the Server Role to sysadmin. Perform this task for the following accounts:
  • GroupDBA DBA Sysadmin group
  • SQL Server service accounts
SSMSSysadmin.png

Copyright FineBuild Team © 2013 - 2015. License and Acknowledgements
Previous Configure Standard Accounts Top Configure DBA Non-Sysadmin Group Next

Last edited May 20, 2015 at 11:10 AM by EdVassie, version 5