Forgot my Azure Data Studio password using SQL Authentication.

Hi Varun_06,

It sounds like you're having trouble logging into Azure Data Studio due to a forgotten SQL Authentication password. No worries, here's what you can do:

Reset the Password via Azure Portal:

• If you're an administrator, you can reset the password for the SQL server directly through the Azure portal:

  - Go to the [Azure portal](https://portal.azure.com/).
  
        - Navigate to your SQL server resource.
  
              - Look for the **Reset Password** option at the top menu bar. If it’s not immediately visible, you may need to click on the ellipsis (`...`) to find it.
  
                    - Enter a new password and confirm it, and then save the changes.
  

1. For Non-Administrator Users:
   • If you need to reset a non-administrator user password, you can use a client application such as SQL Server Management Studio or Azure Data Studio. You would use the ALTER LOGIN statement to change the password. https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-login-transact-sql?view=azuresqldb-current&preserve-view=true

Here’s a quick reference to the relevant documentation you'll need:

• Reset Administrator Password for SQL Server
• Strong Password Guidelines

If you have more specific scenarios or settings, let me know! What type of SQL server account are you using? Are you the admin, or is it a non-admin user account? These details could help narrow down the best approach for resetting your password. Hope this helps!

Follow https://learn.microsoft.com/en-us/answers/questions/1855217/how-do-i-reset-the-admin-user-password-on-my-two-m

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.

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

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin