Windows Authentication for Azure AD principals for SQL Managed Instance is now Generally Available

We are happy to announce the General Availability of Windows Authentication for Azure AD principals for SQL Managed Instance. We released a public preview of this feature in April 2022, since then this feature has been improved and adopted by many customers across industries.

Modernize your security infrastructure with Azure AD and migrate your legacy applications which cannot use Azure AD authentication and must stick with windows authentication for connection. Windows Authentication for Azure AD principals removes the migration blocker and provides support for a broader range of customer applications. This feature enables customers to migrate their applications to SQL Managed Instance with minimal/no changes in the application stack.

SQL Managed Instance is implemented with Azure Active Directory and Kerberos

Windows Authentication for Azure AD principals on managed instances is available for devices or virtual machines (VMs) joined to Active Directory (AD), Azure AD, or hybrid Azure AD. An Azure AD hybrid user whose user identity exists both in Azure AD and AD can access a managed instance in Azure using Azure AD Kerberos.

Enabling Windows Authentication for a managed instance doesn't require customers to deploy new on-premises infrastructure or manage the overhead of setting up Domain Services.

Windows Authentication for Azure AD principals on Azure SQL Managed Instance enables two key scenarios: migrating on-premises SQL Servers to Azure with minimal changes and modernizing security infrastructure.

Note: for Azure China region it will be generally available in a month from now.

Refer our documentation here:

Windows Authentication Overview: What is Windows Authentication for Azure Active Directory principals on Azure SQL Managed Instance? (Preview) - Azure SQL Managed Instance | Microsoft Docs

Setup with modern interactive flow: How to set up Windows authentication for Azure Active Directory with the modern interactive flow (Preview) - Azure SQL Managed Instance | Microsoft Docs

Setup Incoming trust : How to set up Windows Authentication for Azure Active Directory with the incoming trust-based flow (Preview) - Azure SQL Managed Instance

Setup Managed Instance: Configure Azure SQL Managed Instance for Windows Authentication for Azure Active Directory (Preview) - Azure SQL Managed Instance

Podcast: EPISODE 54 - JUNE 14TH, 2022 - [AZURE SQL MI WINDOWS AUTHENTICATION]

Continue reading...