Azure SQL - Change to Mixed Authentication Mode

James Lux 26 Reputation points

I have an Azure SQL Database setup and working. When I set up the SQL Server instance, I selected Windows Azure authentication. I can authenticate with my Windows AD account. I would like to use SQL Authentication as well as Windows Azure (Mixed Mode).

How do I change the base authentication options on the Azure SQL Database?

Thank you.

Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 32,981 Reputation points MVP

    By the default, both authentications can be used if you don't have checked the check button related to "Support only Azure Active Directory authentication for this user". Only when you set that on, you will only be able to authenticate using Azure AD.

    When you set the AD Admin you can go and change your SQL Admin password. So you are having both if the check button is clear,

    This is configured at the Azure SQL logical server level.


    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful