Set up Microsoft Entra authentication | Azure Arc

2022 (16.x)

This article describes a step-by-step process to set up authentication with Microsoft Entra ID

with app registration, and demonstrates how to use different Microsoft Entra authentication

methods.

In this tutorial, you learn how to:

A physical or virtual Windows Server on-premises with an instance of SQL Server 2022

(16.x).

For SQL Server on Azure VMs, review

Enable Microsoft Entra authentication for SQL

Server on Azure VMs.

The server and instance enabled by Azure Arc. For more information, see

Connect your

to Azure Arc.

Access to Microsoft Entra ID is available for authentication purpose. For more

information, see

Microsoft Entra authentication for SQL Server.

A supported version of

Management Studio

is installed on the client machine.

A supported certificate.

Network requirements for enabling Entra ID authentication

７

Note

was previously known as Azure Active Directory (Azure AD).

Create and register a Microsoft Entra application

＂

Grant permissions to the Microsoft Entra application

＂

Create and assign a certificate

＂

Configure Microsoft Entra authentication for SQL Server through Azure portal

＂

Create logins and users

＂

Connect with a supported authentication method

＂