[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2009-04-08
3
Medium Priority
?
241 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 1500 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Learn about cloud computing and its benefits for small business owners.
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

656 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