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

Previous Configure Database Owner Account Manual Configuration Configure Reporting Services Administration Accounts Next

Configure User Accounts

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

FineBuild will create the accounts, but it does not assign any authorities to ther accounts. Further advice on how to deal with user accounts is given in User Account Maintenance in the FineBuild Reference manual.

FineBuild Configure User Accounts

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

Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014 SQL2016
SetupStdAccounts FULL Yes Yes Yes Yes Yes Yes
SetupStdAccounts WORKSTATION Yes Yes Yes Yes Yes Yes
SetupStdAccounts CLIENT N/A 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 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 - 2016. License and Acknowledgements

Previous Configure Database Owner Account Top Configure Reporting Services Administration Accounts Next

Last edited Aug 27, 2016 at 1:27 PM by EdVassie, version 5