How To Disable Azure Active Directory Only Authentication

Introduction

We have different type of authentication types in our azure database. When we create a new SQL database in the azure server, the authentication type will be Azure Active Directory (AD) Authentication. We must disable this authentication type to change that into SQL Server Authentication. This article will show how to disable Azure AD Authentication.

Prerequisites

• An active Azure account
• Created a SQL Server Database in Azure

To disable Azure AD Authentication, we need to follow the steps given below,

•  Log in to your Azure Account

Select SQL databases as given below,

Now select the database which you have created, otherwise, create a new database and then select. Please refer here to create a new database in azure.

After selecting the database, you will be redirected to the page given below. Then you need to select the server you have created for your database.

The next step is to move into the left pane inside Settings. You have to select the Azure Active Directory option as given below.

Now uncheck the option given in the below image and do Save.

 

Conclusion

To disable Azure Active Directory Authentication, we need to follow a few steps, and then we can set SQL Server Authentication. First, we need to move to our server inside our SQL database, which we have created. Then we need to select the Azure Active Directory option inside settings. From there, we can uncheck the option and do save.

Thank You, and Stay Tuned for More

Popular Articles from My Account

• Generate Images In ASP.NET Core MVC Using OpenAI
• ChatGPT Completions In ASP.NET Core Web API