Scenarios for SQL Admin to Update Admin or User Password and Resolving Server Admin Password. Getting update Error

Question

In what scenarios can a SQL Admin update the admin or user password? Getting below error when updating Server admin password 

Error- Cannot alter the login '<>>', because it does not exist or you do not have permission.Msg 15151, Level 16, State 1, Line 1

PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community.

Answer 1

Greetings!

Welcome to Microsoft Q&A forum.

Here are the various scenarios to understand the permissions and roles involved 

• with default SQL Admin (set on the portal) --> you can change the password of additional admin user

•with default SQL Admin (set on the portal) --> you can  change the password of with default SQL Admin (set on the portal) user

•with default SQL Admin (set on the portal) --> you cannot change the password of your Entra Admin (set on the portal) because SQL admin is local to SQL server

•You can reset the default SQL Admin (set on the portal) password via portal /  PowerShell

Powershell : https://learn.microsoft.com/en-us/powershell/module/az.sql/set-azsqlserver?view=azps-12.0.0#example-1-reset-the-administrator-password

•With additional admin user --> you cannot reset the  default SQL Admin (set on the portal) password --> this is your scenario

•with Entra Admin (set on the portal) --> you cannot change the password of  SQL Admin (set on the portal)  user

• with Entra Admin (set on the portal) --> you can change the password of  additional admin user

Thank you!