Audi08
asked on
Change Cluster passwords and sql 2005 cluster- what am i missing
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:WordTestPassPa rtOne!, 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).
Active Node
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.
thanks
audi
Change the SQL Cluster Note Our environment: Active/Passive cluster.
First change the clustering password
cluster /cluster:CLUS1,CLUS2 /changepass:WordTestPassPa
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).
Active Node
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.
thanks
audi
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can I as why the B Grade?
Glad to be of assistance. May all your days get brighter and brighter.
Glad to be of assistance. May all your days get brighter and brighter.
ASKER