Change Cluster passwords and sql 2005 cluster- what am i missing
Posted on 2009-04-08
hi guys, can some correct my steps and order of doing
Change the SQL Cluster Note Our environment: Active/Passive cluster.
First change the clustering password
cluster /cluster:CLUS1,CLUS2 /changepass:WordTestPassPartOne!, B2PartTwo!
SQL Cluster 2005 Change Password.
Logon to the active node server
Start|Run and entering CLUADMIN.EXE. identity
Navigate to the Groups folder in the Cluster Administrator
Navigate to the SQL group and double click on it. (The right hand pane contains the SQL Server services in the cluster)
Right click on SQL Server Fulltext and select Bring Offline.
Right click on SQL Server Agent and select Bring Offline.
Right click on SQL Server and select Bring Offline.
: Open up the services.msc.
Tip: Double click on the Log On As column in the right pane and the SQL Server Service Account should float up to the top of the list (or very near to it).
For each SQL Server service account password to change.
Select the SQL Server service to be changed.
Right click and select Properties.
Select the Log On tab.
Modify the password of the selected SQL Server service.
Passive Node :Repeat the steps for active node.
Go back to the Cluster Administrator
(The right hand pane contains the SQL Server services in the cluster)
Right click on SQL Server Fulltext and select Bring Online
Right click on SQL Server Agent and select Bring Online
Right click on SQL Server and select Bring Online
Note: Do not restart the service(s).
when should i restart node by node to get the changes in effect.?
Let me know in case i am missing or doing some ting wrong.