Episode

How to use Windows Auth with Azure SQL Managed Instance | Data Exposed

with Anna Hoffman, Sravani Saluru

Data Exposed

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)

Chapters

  • 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

Connect

Azure
Azure SQL Managed Instance
SQL