How to Enable SQL Server Authentication ?

Question

I setup a server with Microsoft Entra ID Authentication. I'd like to add the ability to authenticate via SQL Server credentials. However, I cannot locate the authentication settings within the Azure Portal > server settings.

Answer 1

Hi Travis,

Please navigate to your Azure SQL Server in the portal -- Settings -- Microsoft Entra ID blade. Next uncheck Support only Microsoft Entra authentication for this server and click Save, as shown below:

Please click Accept Answer and upvote if the above was helpful.

Thanks.

-TP

Answer 2

You do this under Settings->Microsoft Entra ID by unchecking the box Support only Microsoft Entra authentication for this server. When you do this, you will be informed that this will enable SQL authentication. As always, you need to press Save.