What are the best practises for gMSA with multiple SQL instances on AlwaysON cluster
1
vote
1
answer
1077
views
I have to migrate 8 SQL Server instances to a new SQL Server 2019 AlwaysON cluster. Each instances are going to be replicated to a passive secondary node. We globally want to use gMSA instead of classicals domain accounts.
I cannot find the best practises related to this :
* Should I use the same gMSA for all sql services on all nodes ?
* Should I use a dedicated gMSA for each instance ? (primary and secondary node).
* If yes, Can I install more than one gMSA service on each node ?(
Install-ADServiceAccount gMSAsqlservice
)
Thank you
Asked by Mickael
(325 rep)
Mar 22, 2022, 10:06 AM
Last activity: Mar 22, 2022, 01:57 PM
Last activity: Mar 22, 2022, 01:57 PM