Changing the Password on SQL Server 2005 Cluster Service Account

DBA2000
DBA2000 used Ask the Experts™
on
Hi,

I have a two-node SQL Server 2005 Active/Passive cluster.
I need to change the password to the service account, which is a domain account, in Active Directory. What is the proper procedure ... this is a Production server.

The specs are below:
SQL Server 2005 Standard 64 bit
Windows Server 2003, SP3
Active/Passive
The Service Account is a Domain Admin (... I have a reason for it)

Thanks is advance
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Scott PletcherSenior DBA
Most Valuable Expert 2018
Top Expert 2014

Commented:
Chg the pwd in AD.
Chg the pwd for the SQL service(s) using the **SQL tools**, NOT the Windows tools.

Author

Commented:
Thanks!  A couple questions ... to be sure
... I change the PW in AD
... Change the PW in SQL Svr. Config Mgr


Which one do I do first?
... change pw in active node first, failover to passive nore, reboot
... go to the now active nood and do same ??

please validate for me.

Thanks
Senior DBA
Most Valuable Expert 2018
Top Expert 2014
Commented:
Woah ... I don't think you need a reboot, as long as you go thru the SQL tools.

I guess I would change the passive node first; I don't think it really matters.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial