QuestionQ71

VerifiedSecure identity and access

You have a hybrid Azure Active Directory (Azure AD) configuration.

All users have Windows 10 computers that are hybrid Azure AD joined.

You have an Azure SQL database configured to support Azure AD authentication.

Database developers must connect to the SQL database by using Microsoft SQL Server Management Studio (SSMS) and authenticate by using their on-premises Active Directory account.

You need to tell the developers which authentication method to use in SSMS to connect to the SQL database. The solution must minimize authentication prompts.

Which authentication method should you tell the developers to use?

Explanation

Active Directory Integrated authentication uses the signed-in Windows user’s credentials. For Microsoft Entra hybrid identities, hybrid-joining the on-premises AD environment enables federated Windows identities to use single sign-on when connecting to Azure SQL, minimizing additional authentication prompts.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!