

It allows password rotation in a single place.Ĭustomers can manage database permissions using external (Azure AD) groups. It helps stop the proliferation of user identities across servers. It provides an alternative to SQL Server authentication. Central ID management provides a single place to manage database users and simplifies permission management. With Azure AD authentication, you can centrally manage the identities of database users and other Microsoft services in one central location. OverviewĪzure Active Directory (Azure AD) authentication is a mechanism to connect to your SQL resource by using identities in Azure AD.

To learn how to create and populate Azure AD, and then configure Azure AD with Azure SQL Database, Azure SQL Managed Instance, and Synapse SQL in Azure Synapse Analytics, review Configure Azure AD and Azure AD with SQL Server on Azure VMs. This article provides an overview of using Azure Active Directory to authenticate to Azure SQL Database, Azure SQL Managed Instance, SQL Server on Windows Azure VMs, Synapse SQL in Azure Synapse Analytics and SQL Server for Windows and Linux by using identities in Azure AD.
