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

5. SQL Server 2019 - Database Scoped Configurations & Azure AD Authentication

Key Improvements:
Database Scoped Configurations: Allows per-database settings (including authentication) to sync across replicas.
Azure AD Authentication: Users can authenticate without SQL logins, reducing the need for synchronization.

Steps for Database Scoped Configurations:
Enable Database Scoped Authentication

ALTER DATABASE SCOPED CONFIGURATION SET IDENTITY_CACHE = ON;

Advantages:
Minimizes login synchronization by allowing per-database authentication.
Works well in Azure environments with Azure AD Authentication.

Limitations:
SQL logins still require manual synchronization