How to configure azure my sql server with Azure active directory user login

Hi Team,

I have configured new mysql server with azure active directory authentication using below link, but its not working can you please share the steps to configure

Link - https://learn.microsoft.com/en-us/azure/mysql/single-server/how-to-configure-sign-in-azure-ad-authentication

Vedant Desai 631 Reputation points

2023-05-16T12:48:59.8933333+00:00
Hey,

here are the steps to configure Azure Active Directory authentication for your Azure Database for MySQL server:

Go to the Azure portal and open your Azure Database for MySQL server.

Click on the "Settings" tab.

In the "Authentication" section, select "Azure Active Directory".

Click on the "Save" button.

Azure will now create an Azure Active Directory application for your Azure Database for MySQL server. You will need to provide the following information when creating the application:

Application name: A name for your application.

Application ID: The application ID will be generated for you.

Directory (tenant): The directory (tenant) that your application will be created in.

Sign-on URL: The sign-on URL will be generated for you.

Once you have created the Azure Active Directory application, you will need to configure your Azure Database for the MySQL server to use it. To do this, follow these steps:

In the Azure portal, open your Azure Database for MySQL server.

Click on the "Security" tab.

In the "Authentication" section, select "Azure Active Directory".

In the "Application ID" field, enter the application ID for your Azure Active Directory application.

In the "Directory (tenant)" field, enter the directory (tenant) that your application was created in.

In the "Sign-on URL" field, enter the sign-on URL for your Azure Active Directory application.

Click on the "Save" button.

Your Azure Database for MySQL server is now configured to use Azure Active Directory authentication. You can now sign in to your Azure Database for MySQL server using your Azure Active Directory credentials.

Please don't forget to click on

button if you find this helpful.
Vedant Desai 631 Reputation points

2023-05-16T12:49:50.15+00:00

Please don't forget to click on

button if you find this helpful.
GeethaThatipatri-MSFT 27,717 Reputation points Microsoft Employee

2023-05-16T19:57:23.9133333+00:00

@dhanasekaranDevOps aximsoft Welcome to the Microsoft Q&A forum, Thanks for posting your question.

When you say it is not working what error you are facing can you please share the error details for more understanding?

Regards

Geetha
dhanasekaranDevOps aximsoft 1 Reputation point

2023-05-17T02:56:07.7933333+00:00

Hi vedant,

Some of the options are not available in azure portal steps what you shared
ShaktiSingh-MSFT 13,751 Reputation points Microsoft Employee

2023-05-17T03:46:15.1266667+00:00

Hi dhanasekaranDevOps aximsoft •,

Could you please provide more details as mentioned in the above comment by Geetha so that we can assist you.

Thanks
dhanasekaranDevOps aximsoft 1 Reputation point

2023-05-17T03:48:59.7866667+00:00

I need a clear steps to configure azure Mysql server with AD User Authentication
GeethaThatipatri-MSFT 27,717 Reputation points Microsoft Employee

2023-05-18T12:15:48.51+00:00

@dhanasekaranDevOps aximsoft Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer, if you have any further queries do let us know.

Regards

Geetha

1 answer

GeethaThatipatri-MSFT 27,717 Reputation points Microsoft Employee

2023-05-17T16:05:12.92+00:00

Hi @dhanasekaranDevOps aximsoft Since you have already created the Azure Mysql flexible server here are the steps you can follow to enable AAD authentication

Step 1 Add a user-assigned Managed Identity to your Azure DB for the Mysql Flexible server

a. Go to Managed Identities from the portal and click on create

b.create a managed identity by selecting your subscription, resource group, and region as shown below once all details are entered click on review create

c. once the validation is passed click on create

Step2 Enable AAD Authentication on your Flexible server

a. go to your Mysql flexible server under security select authentication

b. select MySQL AAD authentication

c. add user-assigned managed identity which you have created in step 1

d. select the Azure active directory administrator and click on save

Once all the steps are completed click on server parameters under setting and on aad_auth as shown below

I hope this information helps, please let me know if you are facing any issues at any step

Regards

Geetha
Please sign in to rate this answer.

0 comments No comments
Sign in to comment