Configure User Accounts - SQL-FineBuild/Common GitHub Wiki
| 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.
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.
-
Create required Windows Accounts
Run the following command to create each Windows Account
CREATE LOGIN [_WinLoginnn_] FROM WINDOWS -
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 |
|---|