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

2. SQL Server 2014 - Partial Automation with Contained Users

Improvements:
Contained Users introduced to minimize login synchronization issues.
Database-level authentication reduces dependency on instance-level logins.
Steps:
Enable Contained Database Authentication

EXEC sp_configure 'contained database authentication', 1;
RECONFIGURE;

Create a Contained User

USE MyDB;
CREATE USER ContainedUser WITH PASSWORD = 'SecurePassword';

Limitations:
Still does not sync instance-level logins.
Limited support for server-level security objects.