Server Password change on Mac

Question

Does anyone know how to change password inside azure data studio on a MacBook m1?

Answer 1

Hello Kasper Søballe Poulsen (EAA23KAPO)

Azure Data Studio itself doesn't have a built-in feature to change your password for connecting to Azure resources like SQL Databases. There are, however, a couple of ways to achieve this on your MacBook M1:

1. Change your Azure Active Directory (AAD) password:

• Open a web browser on your MacBook M1.
• Go to the Microsoft Azure portal: https://azure.microsoft.com/en-us/get-started/azure-portal.
• Sign in to your Azure account using your current username and password.
• Click on your profile picture or initials in the top right corner.
• Select "Security settings" from the menu.
• Under "Password", click on "Change password".
• Follow the on-screen instructions to create and confirm your new password.

Once you've changed your AAD password, you can use the new password to connect to your Azure SQL Database in Azure Data Studio. 2. Use tools like the Azure CLI or Azure PowerShell:

• Install the Azure CLI or Azure PowerShell on your MacBook M1.
• Use these tools to connect to Azure using your existing credentials.
• Once connected, you can use specific commands to change your password for Azure SQL Server or other Azure resources.

Here's an example using Azure CLI:

az account set-credential --username <your_username> --password <your_current_password>
az sql server update password --resource-group <resource_group_name> --server-name <server_name> --administrator-login <administrator_login> --password <your_new_password>

Important Note:

• Replace <your_username>, <your_current_password>, <resource_group_name>, <server_name>, and <administrator_login> with your actual information.
• Be cautious when using command-line tools to manage sensitive information like passwords.

By following these steps, you can securely change your password for connecting to Azure resources from your MacBook M1 within Azure Data Studio.

Answer 2

What for a "Server password"? Do you mean the password of your SQL login? With plain T-SQL: https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-login-transact-sql?view=sql-server-ver16

Answer 3

@Kasper Søballe Poulsen (EAA23KAPO)
If you are talking about a SQL Login (so not Windows auth for SQL Server, or Entra for Azure/SQL on VM), then the password can be changed within Azure Data Studio, via the UX or via T-SQL. Please see answers above from Olaf Helper and innovation gadget and dont' forget to mark as accept answer wherever information provided were helpful. Regards, Oury