Solved

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

Posted on 2009-04-08
3
214 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Connecting two servers 30 83
Migration of AD user accounts from Server 2003 to 2012R2 5 85
SQL Query with Sum and Detail rows 2 50
Windows Services - Run a Program Grey Out 3 24
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…
Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

803 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