changing sql login password in sql 2008 cluster environment

Last Post 04 Jul 2011 11:15 PM by ctseah. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
ctseah
New Member
New Member

--
01 Jul 2011 09:03 PM
Hi forumers,

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.

Regards





rm
New Member
New Member

--
02 Jul 2011 08:41 AM
Changing sql login's password in clustered sql instance is no difference from standalone instance.
ctseah
New Member
New Member

--
04 Jul 2011 11:15 PM
Oh, I see.

Thanks


Acceptable Use Policy
---