We help IT Professionals succeed at work.

steps  to change sql service account password in windows clustered environment

Medium Priority
1,574 Views
Last Modified: 2013-11-29
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
Comment
Watch Question

Senior Software Developer
CERTIFIED EXPERT
Top Expert 2009
Commented:
As far as I know you should do this using SQL Enterprise Manager with all nodes running.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Most Valuable Expert 2014

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.
EugeneZ ZhitomirskySQL SERVER EXPERT
CERTIFIED EXPERT

Commented:


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
Most Valuable Expert 2014

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.
Most Valuable Expert 2014

Commented:
http:/Q_24124615.html#23611304

Either mine or Delete -- No refund. I'd lean to the delete. Not really significant to the PAQ.
EugeneZ ZhitomirskySQL SERVER EXPERT
CERTIFIED EXPERT
Commented:
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.                "
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.