im trying to reset password for my SQL in azure

Question

Hi everyone, i think i hve forgot my password to my sql account.

i im trying ways to reset it, by nithing helps, any idea on this?

Answer 1

Hey there sainu

Thats a good question and thanks for using QandA platform,

Guess you can use use CLI to update the password?

az mysql flexible-server update --resource-group myresourcegroup --name mydemoserver --admin-password <new-password>

go through this similar thread hope it helps.

https://learn.microsoft.com/en-us/answers/questions/393443/how-to-recover-lost-password-for-sql-azure

Kindly accept the answer if it did, thank smuch,

Answer 2

Hi @sainu

Are you getting any error?

You can reset the password from Azure Portal. Please navigate to your Azure SQL Server and click "Reset Password" as shown below.

Or You can reset the password using CLI command

az sql server update --resource-group <ResourceGroupName> --name <Servername> --admin-password <NewAdminAccountPassword>

Or by PowerShell

Set-AzureRmSqlServer -ResourceGroupName <ResourceGroupName> -ServerName <ServerName> -SqlAdministratorPassword (ConvertTo-SecureString "<NewAdminAccountPassword>" -AsPlainText -Force)

Thank You!

Answer 3

Hello sainu ,

Thanks for reaching out in the Microsoft Q&A!

To reset your SQL password in Azure, follow these steps:

1. Sign in to the Azure portal using your Azure credentials.
2. Search for SQL servers in the Azure portal search bar and press Enter.
3. Locate your SQL server (the one containing your database) and click on it.
4. In the server menu , click "Reset password" under "Settings."
5. Set a strong new password for your SQL server admin account, confirm it, and click "Save."

If you find this helpful, please accept this answer to close the thread. Thanks!