QuestionQ129

VerifiedImplement Azure security

You manage an Azure SQL database that supports Azure AD authentication.

You need to ensure that database developers can connect to the SQL database by using Microsoft SQL Server Management Studio (SSMS). You must also ensure that the developers authenticate by using their on-premises Active Directory account. Your approach should minimize authentication prompts.

Which of the following should you implement?

Explanation

Active Directory integrated authentication uses Integrated Windows Authentication with the developer’s existing on-premises Active Directory credentials, provided the on-premises directory is joined to Microsoft Entra ID. On a domain-joined machine, it enables access to Azure SQL without prompting for credentials, minimizing authentication prompts.

Learn more

Community Discussion

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