July 7, 2009 at 2:30 am
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
July 8, 2009 at 9:19 am
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.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
July 9, 2009 at 9:58 pm
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
July 10, 2009 at 7:36 am
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 !
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
July 10, 2009 at 12:18 pm
You should not change password thru services.msc. Instead you should change it thru sql server configuration manager.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply