Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1364
  • Last Modified:

steps to change sql service account password in windows clustered environment

i want to to change the sql service account pasword in 2 node clustered environment ,here server is running with windows 2003, with sql server 2000. and running with critical applications
0
balajibabuji
Asked:
balajibabuji
  • 3
  • 2
2 Solutions
 
Ted BouskillSenior Software DeveloperCommented:
As far as I know you should do this using SQL Enterprise Manager with all nodes running.
0
 
Jim P.Commented:
We are a SQL 2005 cluster -- never clustered SQL 2000. I've never had success doing it in the management studio, or via the SQL Server Config manager.

Best way I have found is shut down the Server and Agent and then make the change on the services themselves.
0
 
Eugene ZCommented:


should be no problem just do 1 by 1:
 if you start from your active node server->  do it from %SystemRoot%\system32\services.msc
when 1st node change done from cluadmin.exe (cluster admin GUI)  failover  sql server resources to another node- then login there and do as above
then switch the node back
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
Jim P.Commented:
>>   failover  sql server resources to another node- then login there and do as above

If you are using MyDomain\DBMgr for the SQL Services and shut down the services on the active node, and don't do the inactive node, as soon as you flip it and try to bring up the services on the inactive node you will get an authentication error.

In addition if it is up on the active node -- you change the password in the AD -- any new process from the SQL Agent that goes to the OS will choke from the old password being in use.
0
 
Jim P.Commented:
http:/Q_24124615.html#23611304

Either mine or Delete -- No refund. I'd lean to the delete. Not really significant to the PAQ.
0
 
Eugene ZCommented:
Answer:

Please see the Vendor (Microsoft) recommendations and instructions "How to change service accounts for a clustered computer that is running SQL Server'

http://support.microsoft.com/kb/239885

 I"f you must change the account (password)  under which the SQL Server               virtual server runs, you must use SQL Server Enterprise Manager. Using this tool to                         change the service password will make the change on all the nodes and grant the                         necessary permissions to the selected user account.                "
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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