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

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

Configure Service Account Names

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.
ServiceAccountSelect.png
2) Click on Browse, located beside the Account Name box.
ServiceAccountProperties.png
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.
ServiceAccountPassword.png
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.
ServiceAccountConfirm.png
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.

9) Exit the SQL Server Configuration Manager using File -> Exit.

Copyright © 2011 - 2014 Edward Vassie. License and Acknowledgements
Previous Configure SQL Network Protocols Top Configure SQL Startup Parameters Next

Last edited Nov 4, 2014 at 1:21 PM by EdVassie, version 13