Configure User Accounts

Previous Configure Database Owner Account	Manual Configuration	Configure msdb Database Next

FineBuild can add both Windows and SQL accounts to SQL Server.

Using the process described here, SQL FineBuild will create the accounts, but it does not assign any authorities to ther accounts. If it is required to create accounts with associated authorities, a better approach is to use AutoConfig Processing.

FineBuild Configure User Accounts

The User Accounts configuration relates to Process Id 5CG. It is controlled by the parameters below:

SQL Version	Parameter	FULL Build	WORKSTATION Build	CLIENT Build
SQL2019	/SetupStdAccounts:	Yes	Yes	N/A
SQL2017	/SetupStdAccounts:	Yes	Yes	N/A
SQL2016	/SetupStdAccounts:	Yes	Yes	N/A
SQL2014	/SetupStdAccounts:	Yes	Yes	N/A
SQL2012	/SetupStdAccounts:	Yes	Yes	N/A
SQL2008R2	/SetupStdAccounts:	Yes	Yes	N/A
SQL2008	/SetupStdAccounts:	Yes	Yes	N/A
SQL2005	/SetupStdAccounts:	Yes	Yes	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 User Accounts:

Parameter	Default Value	Description
/NumLogins:	20	Number of User Accounts to process
/WinLogin01: to /WinLogin99:	none	Name of Windows Account to add to SQL Server
/UserLogin01: to /UserLogin99:	none	Name of SQL Account to add to SQL Server
/UserPassword01: to /UserPassword99:	none	Password for relevant SQL Account

FineBuild will automatically create the specified User Accounts.

• Windows Accounts: FineBuild will read parameters /WinLogin01: to /WinLogin99: stopping at the number given by /NumLogins: and create a login for any account found.
• SQL Accounts: FineBuild will read parameters /UserLogin01: to /UserLogin99: stopping at the number given by /NumLogins: and create a login for any account and password found.

Top

---

Manual Configure User Accounts

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

1. Create required Windows Accounts

   Run the following command to create each Windows Account

   CREATE LOGIN [_WinLoginnn_] FROM WINDOWS
   

2. Create required SQL Accounts

   Run the following command to create each SQL Account

   CREATE LOGIN [_UserLoginnn_] WITH PASSWORD='_UserPasswordnn_'
   

Copyright FineBuild Team © 2013 - 2020. License and Acknowledgements

Previous Configure Database Owner Account	Top	Configure msdb Database Next