From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Configure authentication with Active Directory and Entra ID

Configure authentication with Active Directory and Entra ID

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Configure authentication with Active Directory and Entra ID

“

- Welcome back. This is lesson 4.1, Configure Authentication by Using Active Directory and Entra ID. So in addition to the SQL authentication, on premises SQL server installations rely on active directory for authentication, which uses domain controllers to provide identity management. In Azure, Azure SQL database and Azure SQL Management both use Microsoft Entra ID, formally know as Azure Active Directory. Now Microsoft Entra ID adds additional support for conditional access and multi-factor authentication, which AAD or Active Directory did not provide. So when working with SQL offerings in Azure they port the standard SQL server authentication, and that is independent authentication that uses username and password stored in the master database. But they also support Entra ID, which is a cloud based identity and access management service, which uses critical HTTPs security protocol. And this provides a more secure authentication process. SQL authentication transmits username and…

Contents