im trying to reset password for my SQL in azure

sainu 20 Reputation points
2024-05-27T17:14:02.4833333+00:00

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?

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Azar 20,680 Reputation points
    2024-05-27T17:42:59.72+00:00

    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,

    1 person found this answer helpful.
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Rahul Randive 9,011 Reputation points Microsoft Employee
    2024-05-27T17:20:15.6066667+00:00

    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.

    96250-image.png

    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!

    0 comments No comments

  2. Gowtham CP 3,655 Reputation points
    2024-05-27T17:25:52.5766667+00:00

    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!

    0 comments No comments