Previous Configure Reporting Services Instance Manual Configuration Configure Sysadmin Accounts Next

Configure Standard Accounts

FineBuild can configure a number of standard Windows accounts should be added to SQL Server.

Details of the accounts that are added is given below:
Description
Account that is running the SQL FineBuild install process
DBA Team Sysadmin group
DBA Team Non-Sysadmin group
Windows Network Service account
SQL Server Service account
SQL Agent Service account

Security Compliance

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

FineBuild Configure Standard Accounts

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

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

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

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

FineBuild will automatically add these accounts to SQL Server.
Top

Manual Configure Standard Accounts

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

The same process is used to add all of these accounts.

1) Use SQL Server Management Studio to connect to the SQL instance. Navigate to Logins and select New Login.
SSMSNewLogin.png
2) Click Search to identify the new login.
SSMSSearch.png
3) Use the process Find Group on Domain or Find User on Domain with each of the accounts listed above to add them to SQL Server.

Copyright FineBuild Team © 2013 - 2015. License and Acknowledgements
Previous Configure Reporting Services Instance Top Configure Sysadmin Accounts Next

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