How to configure AAD Admin for Azure SQL MI

In Azure SQL Managed Instance (SQL MI) Azure AD integration allows Azure AD users to login to SQL MI using their Azure AD credentials. This capability is more secure than SQL Server authentication and can also be MFA-enabled for an additional layer of security. This video describes the permissions and process needed to configure the Azure AD admin for a SQL MI instance. Once the admin is configured, additional Azure AD users and groups can be added to the SQL MI target instance.

Chapters:
00:08 Introduction
00:17 Permissions required to set the Azure AD admin
01:07 Granting permissions to read Azure AD
01:27 Setting the Azure AD admin

Recommended content:
Provision Azure AD admin (SQL Managed Instance): https://learn.microsoft.com/en-us/azu...
Tutorial: Security in Azure SQL Managed Instance using Azure AD server principals (logins): https://learn.microsoft.com/en-us/azu...
What is Azure SQL Managed Instance?: https://learn.microsoft.com/en-us/azu...