Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Chaning SQL Cluster Service Account Passowrd Expand / Collapse
Author
Message
Posted Tuesday, July 7, 2009 2:30 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 4:49 AM
Points: 89, Visits: 78
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
Post #748368
Posted Wednesday, July 8, 2009 9:19 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:15 PM
Points: 3,190, Visits: 2,284
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."
Post #749395
Posted Thursday, July 9, 2009 9:58 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 4:49 AM
Points: 89, Visits: 78
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

Post #750822
Posted Friday, July 10, 2009 7:36 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:15 PM
Points: 3,190, Visits: 2,284
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."
Post #751038
Posted Friday, July 10, 2009 12:18 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:52 PM
Points: 1,193, Visits: 3,148
You should not change password thru services.msc. Instead you should change it thru sql server configuration manager.
Post #751318
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse