Sign in to confirm you’re not a bot
This helps protect our community. Learn more
How to use Windows Auth with Azure SQL Managed Instance | Data Exposed
60Likes
6,473Views
2022Sep 15
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 single-sign-on 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 built-in Azure AD support
  • Works on both Domain Joined, and Azure Active Directory Joined machines
  • Works in double-hop 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/en-us/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

Follow along using the transcript.

Microsoft Developer

589K subscribers