balajibabuji
asked on
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
should be no problem just do 1 by 1:
if you start from your active node server-> do it from %SystemRoot%\system32\serv
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
>> 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.
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.
http:/Q_24124615.html#23611304
Either mine or Delete -- No refund. I'd lean to the delete. Not really significant to the PAQ.
Either mine or Delete -- No refund. I'd lean to the delete. Not really significant to the PAQ.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Best way I have found is shut down the Server and Agent and then make the change on the services themselves.