Windows Authentication for Azure SQL Managed Instance

In this video Sravani Saluru wlks us through windows authentication for Azure AD principals for SQL Managed Instance. We discuss about modern interactive and incoming trust based flow. SQL MI settings that need to be enabled for the windows authentication  to work .In the demo we show connecting to SQL MI using modern interactive flow and walk you through  few commands that can be used for troubleshooting Kerberos issues. At the end we show how to connect from SSMS and other tools like profiler and extended events seamlessly using windows authentication for AAD principal. Chapters: 00:00:00 Modern interactive flow and incoming trust based flow 00:01:26 Managed Instance settings 00:02:13 Demo : verify the client 00:03:06 Verify the Kerberos tokens. 00:03:32 Connect using SSMS and other tools 00:04:17 Verify trust object with Azure AD Kerberos Recommended content: What is Windows Authentication for Azure Active Directory principals on Azure SQL Managed Instance?: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-overview?view=azuresql How to set up Windows Authentication for Azure SQL Managed Instance using Azure Active Directory and Kerberos: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-setup?view=azuresql How to set up Windows Authentication for Azure Active Directory with the modern interactive flow: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-setup-modern-interactive-flow?view=azuresql How to set up Windows Authentication for Azure AD with the incoming trust-based flow: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-setup-incoming-trust-based-flow?view=azuresql Configure Azure SQL Managed Instance for Windows Authentication for Azure Active Directory: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-kerberos-managed-instance?view=azuresql Troubleshoot Windows Authentication for Azure AD principals on Azure SQL Managed Instance: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-troubleshoot?view=azuresql