Configure Service Account Names - SQL-FineBuild/Common GitHub Wiki

Previous Configure SQL Network Protocols Manual Configuration Configure SQL Startup Parameters Next

FineBuild can configure Service account names for accounts that cannot be specified during the SQL Server install.

This section is only relevant if SQL Server has been installed as a cluster. The Microsoft SQL Server cluster install process does not allow all of the service account names to be specified. This section deals with changing the service account names for the following services so they use the required accounts.

  • SQL Server Browser
  • SQL Server Full Text Launcher
  • SQL Server Integration Services

FineBuild Service Account name configuration

Automated silent Service Account name configuration relates to Process Id 5AC and will always be performed if SQL Server has been installed as a cluster.

FineBuild also uses the following parameters to help configure the SQL Startup Parameters:

Parameter Default Description
/IsSvcAccount: none Service Account name for Integration Services
/IsSvcPassword: none Service Account password for Integration Services

Top

Manual Service Account Name Configuration

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

  1. Right-click on one of the services above that needs to have its Service Account name changed and select Properties

    Select Service Account

  2. Click on Browse, located beside the Account Name box

    Service Account Properties

  3. Use the process Find User on Domain with the User Name for /IsSvcAccount: to configure the service account for Integration Services

  4. Type and confirm the Password. Click OK to continue

    SQL Server will then change the Service account name for the service, and update any required folder and registry permissions needed for the new account. The password should be recorded in the DBA Password Store

    Service Account Password

  5. Some services may ask you to confirm if it is OK to restart it

    Click Yes if a message similar to the one below is given

    Confirm Service Account

  6. Repeat the above process for any other services that need to have their Service Account name changed, using the new Service Account name and password for the service

  7. Exit the SQL Server Configuration Manager using File -> Exit

Copyright FineBuild Team © 2011 - 2020. License and Acknowledgements

Previous Configure SQL Network Protocols Top Configure SQL Startup Parameters Next