Can SQL Azure Globan Admin & created user passwords be reset/changed?

Question

After I provision a SQL Azure Single DB - with a Global Admin login/password - can it be changed after the initial deployement via SQL Scripts?

Can the passwords for the SQL logins/user created by the above Global Admin - be changed/reset after the initial deployment or setup via SQL Scripts?

https://www.michaelcrump.net/azure-tips-and-tricks145/ ?? – 4c74356b41 Feb 15 '19 at 17:24 — 4c74356b41, Feb 15 '19 at 17:24

Rohit Saigal · Accepted Answer · 2019-02-15T18:53:54.637

RESET PASSWORD FOR SERVER ADMIN

You can do this after initial deployment through any of these - Azure Portal, AZURE CLI, PowerShell or SQL Scripts

SQL

-- You should be connected to Master Database for this Server
ALTER LOGIN [AdminAccountName] WITH Password='New_Password';

Azure PORTAL

Go to Azure portal, click SQL Servers, select the server from the list, and then click Reset Password.

RESET PASSWORD FOR OTHER USERS/LOGIN

Yes, You can do this after initial deployment through SQL Scripts.

Traditional model users

-- You should be connected to Master Database for this Server
ALTER LOGIN login_name WITH PASSWORD = 'New_Password';

Contained Database model users

-- You should be connected to User Database itself
ALTER USER user_name WITH PASSWORD = 'New_Password';

See these links for more details:

1 Answers1