Solved

Change Cluster passwords and sql 2005 cluster- what am i missing

Posted on 2009-04-08
3
217 Views
Last Modified: 2012-05-06
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
Comment
Question by:Audi08
  • 2
3 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 500 total points
ID: 24115976
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
 
LVL 1

Author Closing Comment

by:Audi08
ID: 31568110
thanks

0
 
LVL 38

Expert Comment

by:Jim P.
ID: 24325284
Can I as why the B Grade?

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

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question