Need some advise on changing sql logins' password in sql 2008 cluster environment.
My environment is a 2 node sql cluster. Node A is Active and Node B is Passive.
Node A resides in Server A and Node B resides in Server B.
I need to change the password of the sql logins.
There are about 8 sql logins' password including sa password, which I need to change as part of security measures.
Are there any potential issues or procedures that I need to observe and follow ?
There are also scheduled jobs created using maintenance plan in the system, anything I need to take note of regarding this ? As this is a clustered environment, is there a need for me to do a failover and failback to effect the change of sql logins' password ?
Thanks in advance.