How do I reset the admin user password on my two MS SQL databases

Question

During company re-org the password to the admin user on my prep and prod MS SQL databases has been lost.

How do I get them reset please?

Answer 1

Hi @Duncan, Ross

To reset the password for the server admin, go to the Azure portal, select SQL Servers, select the server from the list, and then select Reset Password.

Please let us know if you have further questions.
If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.

Thank You

Answer 2

Hi Duncan, Ross •,

Welcome to Microsoft Q&A forum.

As I understand, you want to reset Azure SQL Server password.

You may do so using Azure Portal as mentioned by Rahul in the above answer.

Alternatively, you can use Azure CLI/Powershell as shown below:

With Azure CLI:

https://learn.microsoft.com/en-us/cli/azure/sql/server?view=azure-cli-latest#az-sql-server-update

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

With Azure Powershell:

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

Refer this blogpost for full detailed step by step explanation:

https://techcommunity.microsoft.com/t5/azure-database-support-blog/reset-lost-admin-account-password/ba-p/368920

Hope this helps.

Let us know if you face any issue.

Thanks