Markus (4/21/2015)
Some say you must use the Config Manager for the active node
Correct
Markus (4/21/2015)
then update it on the passive node via the Services panel.
Incorrect and I'll tell you why.
The registry hive and settings for the clustered SQL server role are replicated between the nodes. Updating the password on the active node successfully will replicate to the partner.
Markus (4/21/2015)
Our security team has a password vault application/software that keeps track of all service ID/passwords and you can have it update the services automatically which doesn't cause an outage on Win2008. I am assuming it changes the password in the services panel but doesn't really take effect until you restart SQL Server.
All changes to the sql server config should be done via config manager and not services.msc, this is not recommended by Microsoft.
Markus (4/21/2015)
What have other folks done in Clusters for changing just the password for existing Win2008\SQL2008R2 clusters service ID?
As above , top
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉