Changing Password on a SQL Server Cluster

I have a two-node SQL Server Cluster - Active/Passive (these are physical servers)
The following is the config/setup:

OS Name:                   Microsoft(R) Windows(R) Server 2003 Enterprise x64 Edition
OS Version:                5.2.3790 Service Pack 2 Build 3790
SQL Server Standard Ed. 64 Bit; Version 9.00.4053.00; SP3

I need to change the password of  the Domain Service Account that these two services are running under:
SQL Server and SQL Server  Agent

This is a production server; how do I proceed - lowest down-time.

Thank you.
DBA2000Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

65tdRetiredCommented:
Schedule an outage for the time it takes for the SQL service to restart.

Change account / password, will not take affect until SQL service is restarted.

Could do the passive node first but there will still be a SQL outage during failover.
0
65tdRetiredCommented:
Also for SQL 2005 see ms doc:
http://support.microsoft.com/kb/283811

Additional service account info:

http://support.microsoft.com/kb/907557
0
DBA2000Author Commented:
my question is, specifically, from where do you change the PW, Active Directory?, the server's Control Panel services?, Using SQL Server Config Mgr????

Thanks,
D
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

65tdRetiredCommented:
Change the account pw in AD and then change it on the nodes from the services applet.
0
DBA2000Author Commented:
These servers are in an Active/Passive MS Cluster. What are yu refering to as "services applet" To my knowledge, in SQL Server, you make changes from SQL Server Configuration Manger.  Am I missing something?
0
65tdRetiredCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DBA2000Author Commented:
The answer was not specific, too broad ... did not answer the exact question asked.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.