sql server clustering:
We have a situation,



A sql server 2000 cluster on win 2k we inherited with virtual sql server
service accounts running on a domain cluster service account.



The problem is we recently tried to apply SQL SP3 and the setup ask for
the cluster account password which no one has, we thought we could use
any domain-wide account to run the setup but it didn’t work.



Is the right approach now for us to go into the virtual sql server
enterprise manager and change the password (with a new password) for the
cluster account for both sql server and sql agent and then re-run the
sp3 setup with this account.



We just want to be sure that changing the password will maintain the
availability of the cluster



your advice will be appreciated.


--

[quoted text, click to view]

You have to change the cluster account password you have to go in

Control Panel -> Administrative Tools -> Services -> Cluster Service

open the service's property page, go to Log On tab and then changing the
Cluster Admin pwd
You must repeat the previos steps for both nodes of the cluster

[quoted text, click to view]

Bye

--
Luca Bianchi
Microsoft MVP - SQL Server
http://mvp.support.microsoft.com
http://italy.mvps.org

YOu must use EM to change the accounts for the SQL Server
and SQL Server Agent. DO NOT use the Services applet.

If you need to change the server cluster (i.e. Cluster
Service) account, you can do that through Services, but
you will need to stop the Cluster service to do it.

If you use the same account for both SQL's failover
cluster/virtual server and the Windows server cluster, you
will need to change it in 2 places (EM for SQL & services
for Windows). I suggest you change it in EM first.

This is why it is recommended to have two separate domain
accounts for each purpose (SQL, Windows)