Reset password of Azure Managed Instace Login ( not admin user )

Question

Reset password of Azure Managed Instace Login ( not admin )

For admin login we use Set-AzureRmSqlInstance.

Looking to reset a login ( non admin) using a powershell from a Devops pipeline.

Answer 1

Here on GitHub you will find a PowerShell script that executes a stored procedure on an Azure SQL Database. Use the script to execute a stored procedure that changes the password of all logins you want to specify. Inside the stored procedures you will have statements like below:

ALTER LOGIN YourLogin WITH PASSWORD = '2Secr@ts';  

Answer 2

Hi, anonymous user Thanks for the ask and for using the Microsoft Q&A platform.
We are advising users to use the Az PowerShell module instead of AzureRM. Deprecation has been announced for the AzureRM PowerShell module. I don't believe that there's an Azure PowerShell command for resetting user passwords for an Azure SQL-managed instance.
If you are using Azure AD authentication for your managed instance, you would use the Microsoft Graph PowerShell module to reset the password, however, If you connect to MI you should be able to do something like this:
I don’t expect to see it in one of the MI PS modules because it is not an MI setting but something stored within the master as @Alberto Morillo mentioned.

Regards
Geetha