June 2, 2008 at 11:56 am
When I change the service account password using conf manager on one node, it fails when I fail it over to the other node.
Does anyone have a "best practices" for changing service account passwords on a cluster?
thanks
June 2, 2008 at 12:40 pm
It is the same as regular server...
Change the service account and restart the sql services to take effect. you don't need to failover...just offline/online should be fine.
MohammedU
Microsoft SQL Server MVP
June 2, 2008 at 12:50 pm
with clusters you should always work with the virtual sql server - you should not normally use the nodes.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
June 3, 2008 at 8:31 am
The problem I am having is when I change the service account password on one node using config manager, the other nodes are not updated with the password change.
When I fail the instance over to the other node it fails due to password. if I log into the other node and change the password it works.
Why doesn't Config Manager update the service account password on all nodes of the cluster?
This is SQL 2005 EE 64 bit
June 3, 2008 at 8:53 am
Config Mananger, is it connecting to the virtual node or one of the individual nodes?
It might not be cluster aware. I wouldn't be surprised there if you had to manually change both.
June 3, 2008 at 3:58 pm
It looks you have to manually update the password on each node. See
As SSCM is not cluster aware it won't help in getting password resetted from one node.
Manu
June 3, 2008 at 6:56 pm
MohammedU (6/2/2008)
It is the same as regular server...Change the service account and restart the sql services to take effect. you don't need to failover...just offline/online should be fine.
"The password takes effect immediately, without restarting SQL Server." as per BOL (for regualr server?) Need to restart SQL or not?
June 4, 2008 at 6:01 am
I'm amazed I can't change the password on one node and have it propagate to the other nodes. It works fine in SQL 2000.
MANU (6/3/2008)
It looks you have to manually update the password on each node. SeeAs SSCM is not cluster aware it won't help in getting password resetted from one node.
Manu
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply