Solved

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

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

757 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now