In this episode of Data Exposed with Anna Hoffman and Sravani Saluru, they'll discuss the benefits of the newly announced Windows Authentication for Azure AD principals now Generally Available on SQL Managed instance!
Windows Authentication presents additional singlesignon option for SQL Managed Instance Azure AD users. Compared to the previously available options, it brings the following benefits:
Works with legacy drivers, that don't have builtin Azure AD support
Works on both Domain Joined, and Azure Active Directory Joined machines
Works in doublehop scenarios (i.e., IIS impersonation)
00:00 Introduction
01:22 Overview
03:35 How to set it up
06:09 Understanding the flow
06:57 Windows Accesses an Azure AD Kerberos Resource
07:53 How it works
09:00 Demo
✔ Resources:
Windows Authentication for Azure AD principals for SQL Managed Instance is now Generally Available: https://techcommunity.microsoft.com/t...
Windows Authentication for Azure AD principals doc: https://docs.microsoft.com/enus/azur...
Let's connect:
Twitter: Anna Hoffman, / analyticanna
Twitter: Sravani Saluru, / sravani_saluru
Twitter: AzureSQL, https://aka.ms/azuresqltw
Subscribe to our channels for even more SQL tips: https://aka.ms/msazuresqlyt
#AzureSQLMI #ManagedInstance #AzureSQL #SQLServer