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.
Refer our documentation here:
Data exposed Video : https://learn.microsoft.com/en-us/shows/data-exposed/how-to-use-windows-auth-with-azure-sql-managed-...
Windows Authentication Overview: What is Windows Authentication for Azure Active Directory principals on Azure SQL Managed Instance? ...
Setup with modern interactive flow: How to set up Windows authentication for Azure Active Directory with the modern interactive flow (Pr...
Setup Incoming trust : https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-setup-incoming-tru...
Setup Managed Instance: https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-kerberos-managed-i...
Podcast: EPISODE 54 - JUNE 14TH, 2022 - [AZURE SQL MI WINDOWS AUTHENTICATION]