This new feature was already being expected for a while. Out of the blue, while I was delivering an online class, there it was, looking to me. Waiting for me to figure out how it works and explain it to my students.

Luckily, the feature is very simple: You click a checkbox and you will entirely block any SQL User from login to your Azure SQL Database. Only integrated authentication will be accepted. Only AD users will be accepted on Azure SQL DB if you enable this feature.

Enabling Azure Active Directory Authentication

First, we need to enable Azure Active Directory Authentication. This usually is one of the first demonstrations I make in the technical sessions, when I talk about Azure SQL. To enable AAD authentication we need to set an AAD admin for our Azure SQL Server.

The new feature appeared in the same place we need to enable the integrated authentication.

#blogs #azure ad #azure policies #azure sql #azure sql