changing sql login password in sql 2008 cluster environment

Last Post 05 Jul 2011 12:15 AM by ctseah. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ctseah
New Member
New Member

--
01 Jul 2011 10: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 09:41 AM
Changing sql login's password in clustered sql instance is no difference from standalone instance.
ctseah
New Member
New Member

--
05 Jul 2011 12:15 AM
Oh, I see.

Thanks
You are not authorized to post a reply.

Acceptable Use Policy