Process how to automated changing SQL Services account password with PowerShell script instead of using configuration wizard on SQL 2 node Cluster

Ruslana Tsimerman 1

We would like to automate password rotation for SQL Server Services in clustering environment, FCI SQL 2 node Cluster (active-passive), SQL FCI Cluster with 3 sql instances: sql2012,sql2014 and sql2016.. Has anyone automated changing SQL Server services password with PowerShell script instead of using configuration wizard?. Any help greatly appreciated.

Ruslana Tsimerman 1 Reputation point

2021-07-21T19:37:58.347+00:00

we pushed password change via our security software to sql 2012 services on active node, after the failover from active passive, sql server agent is not starting up on a new active node automatically, manual startup works.
Cris Zhan-MSFT 6,626 Reputation points

2021-07-22T07:58:59.37+00:00

Hi，

Please check whether the SQL Server Agent resource depend on SQL Server resources in the failover cluster(check the properties of the sql server agent resource in failover cluster manager). Usually the SQL Server service and agent service will be online on the new active node after failover, even though their start mode may be manual mode.

1 answer

Erland Sommarskog 111.6K Reputation points MVP

2021-07-21T19:55:06.48+00:00

Don't know the answer, but once you only have SQL 2016 you should be able to use gMSA and let Windows deal with it all.
Please sign in to rate this answer.
Ruslana Tsimerman 1 Reputation point

2021-07-21T21:11:11.463+00:00

Thank you for your reply. Yes, this is the issue...
This SQL Cluster has 3 sql instances and they are running using different sql service accounts...
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Process how to automated changing SQL Services account password with PowerShell script instead of using configuration wizard on SQL 2 node Cluster

1 answer

Your answer