SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Chaning SQL Cluster Service Account Passowrd


Chaning SQL Cluster Service Account Passowrd

Author
Message
nitin.dittakavi
nitin.dittakavi
SSC Journeyman
SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)

Group: General Forum Members
Points: 89 Visits: 83
Hi,

We have a W2k3 with SQL2005SP2.
No of clusters - 2
No of Nodes for each Cluster - 4
No of instances per Cluster - 8 Active - online, 8 Offline
Type - Active Active cluster.

We are using the same domain account to run both the cluster service and the SQL instances. I did like to chagne the password for the Service now and have the following queries:

Is there are way by which I can update the passwords for all the services running with this account at one go? The reason being I have seen posts that describe chaning the password for each instance on each node, Change the cluster Service account on each node. This would be a long task taking into account the no. of instances we have. (16 per cluster * 3 per Instance (sql, agent, FT) * 4 nodes * 2 sites) = 384. + 8 (Cluster Service account - 1 for each node)

This will take a considerable amount of time and will also have a longer downtime. So wanted to know if there is any script / automated tool that can be used to update the passwords for these servies across nodes and instances.

Let me know if more information is required.

Thanks in advance...

Dittakavi Nitin
Rudyx - the Doctor
Rudyx - the Doctor
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4833 Visits: 2503
You should be able to modify the password through the services msc beforehand. Do not restart any services until the password(s) have been changed via the services msc on all nodes of any given cluster. Once you have completed this you can then stop/start each instance and optionally test failovers.

Normally using the services msc is not the recommended tool since special directory and registry permissions are set by the SQL Configuration Manager when it is used. However since it is a password change only this is not an issue.

Just remember that if you change the actual service account you do need to use the SQL Configuration manager.

Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
nitin.dittakavi
nitin.dittakavi
SSC Journeyman
SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)

Group: General Forum Members
Points: 89 Visits: 83
Do we have any tool that would enumerate the list of services that are being run under a given account if we give the list of servers, and service account as an input. Surely there must be a way to change the service accounts across environment in more simple way rather than changing one each server manually.

This would be helpful to change the pwd once i change the cluster pwd on the domain and then use this tool to update the service accounts.

Regards

Dittakavi Nitin
Rudyx - the Doctor
Rudyx - the Doctor
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4833 Visits: 2503
We use a software package called ECM - Enterprise Change Management - we have 250+ SQL Servers - it handles non-clustered SQL Servers but has issues wioth clusters !

Thats why we do it manually - 16 and growing n+1 clusters and a handful of active/passive clusters quarterly !

Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Pei Zhu-415513
Pei Zhu-415513
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1624 Visits: 4089
You should not change password thru services.msc. Instead you should change it thru sql server configuration manager.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search