question

SQLDBA-9591 avatar image
0 Votes"
SQLDBA-9591 asked Criszhan-msft edited

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

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.

sql-server-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·

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.

0 Votes 0 ·

1 Answer

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered SQLDBA-9591 commented

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·