April 19, 2007 at 7:46 am
I have a clustered instance and the service account password expired. I changed the password in windows (logged in as the account and changed the password). The service stopped so I cannot use Enterprise manager to change the password. I read that changing the password using the control panel/services could cause problems with the instance.
How does one change the service account password on a cluster when the services have stopped?
Thanks
April 20, 2007 at 2:56 am
Changing the service account PASSWORD using control panel/services should never cause you a problem. The only thing that EM does with the password is to store it in the same registry entries that the services applet uses.
Changing the service account NAME using control panel/services can cause you a problem. When you change the service account name in EM, it updates a load of file and registry permissions to give the new account the access it needs. There is a KB describing the manual work required if you change the account name using the services applet.
All service accounts should be set to 'password never expires', but you should plan to do regular manual password changes at least once per year, and more often if your regulatory or security environment requires it.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 20, 2007 at 5:08 am
Thanks for the reply. It turns out that what I'd read didn't go far enough about not using the control panel/services to change the password. In order to use the CP you have to change the password on BOTH nodes manually whereas using Enterprise Mgr handles that for you.
JC III
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply