How has the SQL Server Always On Availability Group (AG) synchronized the Security Objects Across Replicas (2012 - 2025)? - Part III

3. SQL Server 2016 - Support for Group Managed Service Accounts (gMSA)

New Features:
Group Managed Service Accounts (gMSA) introduced for automatic password management.
Logins can be linked to Active Directory (AD) accounts for automatic authentication across replicas.
Steps:
Create gMSA in Active Directory

Register gMSA in SQL Server

CREATE LOGIN [Domain\SQLgMSA$] FROM WINDOWS;

Advantages:
Reduces manual login creation.
Simplifies authentication in Active Directory environments.

Limitations:
Still no automatic login synchronization for SQL logins (only for Windows logins).