Changes the password for the specified login.
ALTER LOGIN login_name PASSWORD="new_password"
Specifies the login to change.
A case-sensitive password.
To run this command you need one or more of these permissions:
MANAGEMENT permissions required on the master database.
MANAGEMENT permissions default to members of the admin fixed database role. Members of the admin fixed database role can transfer permissions to logins and users.
Changing a password will not have any effect on current connections and will only take effect on the next login.
Change a password.
The following example changes the
system password to
ALTER LOGIN system PASSWORD = "orangeKitten";