Native Windows principals for SQL Managed Instance | Data Exposed

This capability simplifies the migration to SQL Managed Instance and unblock the migration of legacy applications that are tied to windows logins. This feature plays a vital role for SQL Managed Instance link. Managed Instance link enables near real-time data replication between SQL Server and SQL Managed Instance, the read-only replica in the cloud prevents creation of Microsoft Entra principals. The Windows authentication metadata mode allows customers to use an existing Windows login to authenticate to the replica if a failover happens.

Watch now

Resources:

View/share our latest episodes on Microsoft Learn and YouTube!