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...