ALTER LOGIN WITH PASSWORD causes error Msg 15151, Level 16, State 1, Line 4

Problem:

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.

Resolution:

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