• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

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: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).

 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
0
Audi08
Asked:
Audi08
  • 2
1 Solution
 
Jim P.Commented:
You're in the ball park.

The way I did it is created a custom MMC/MSC that I run from my client.

Do a Start --> Run --> RunAs /USER:MyDomain\MyAdminID "mmc"
It should pop up asking for a password.

Then do an Add/Remove Snap-in --> Add --> Services snap-in. It will ask "Local Computer". Select "Another Computer" and put in the nodes (server's) actual name. Repeat for each node in the cluster(s). Save the setup to an MSC.

Then from there run the cluster admin and shut down the instance(s). Go to the services and change the passwords and then restart.

Note: I deleted the SQL Server Fulltext from Cluster Admin in all instances and put the service into manual mode in all instance on all servers in my clusters. I'm working fine without it.

It doesn't buy you anything but overhead unless you actually use it. M$ put it into auto-install to show the grat new features of 2005. The majority of my apps are written to SQL 2000 or lightly 2005 oriented.
0
 
Audi08Author Commented:
thanks

0
 
Jim P.Commented:
Can I as why the B Grade?

Glad to be of assistance. May all your days get brighter and brighter.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now