Azure Active Directory authentication for SQL Server 2022


Part of the SQL Server 2022 blog series.

Azure Active Directory (Azure AD) authentication is now supported for SQL Server 2022 preview on-premises for Windows and Linux Operating Systems.

Azure AD Authentication methods 

The new functionality extends existing authentication modes, such asSQL authentication and Windows authentication, allowing users to connect to SQL Server 2022 using the following Azure AD authentication methods:

 Azure Active Directory Password  Azure Active Directory Integrated  Azure Active Directory Universal with Multi-Factor Authentication  Azure Active Directory access token 

For more details, see Azure Active Directory (Azure AD) authentication for SQL Server overview.

The new authentication mode using Azure AD is based on the central authentication repository