A user that was not part of the sysadmin role attempted to change its own password using the SQL syntax, “ALTER LOGIN WITH PASSWORD”.
Returned is the following error:
Msg 15151, Level 16, State 1, Line 4
Cannot alter the login ‘ < username > ‘, because it does not exist or you do not have permission.
The user was able to change its own password using the stored procedure sp_password, however it must provide the old password for the statement to complete successfully.
SP_PASSWORD @OLD = ' < old password > ', @NEW = ' < new password > '; GO