Azure SQL - Change to Mixed Authentication Mode

James Lux 26 Reputation points
2022-03-21T16:45:57.887+00:00

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.
Jim

Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 32,981 Reputation points MVP
    2022-03-21T20:46:23.423+00:00

    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.

    185348-image.png

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful