Using Azure Arc in the Azure portal, register a host server (an on-premises Windows or Linux server) with a SQL Server 2022 instance installed on this server.Steps for Azure AD setup based on the diagram above:

The diagram below presents two stages required for a SQL Server 2022 instance to support Azure AD authentication: Enable Azure AD authentication in SQL Server 2022

The new authentication mode using Azure AD is based on the central authentication repository provided for Azure cloud. This functionality is already supported for Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics.

Azure Active Directory Universal with Multi-Factor Authenticationįor more details, see Azure Active Directory (Azure AD) authentication for SQL Server overview.

The new functionality extends existing authentication modes, such as SQL authentication and Windows authentication, allowing users to connect to SQL Server 2022 using the following Azure AD authentication methods: Azure Active Directory (Azure AD) authentication is now supported for SQL Server 2022 preview on-premises for Windows and Linux Operating Systems.

Active directory mfa on premise