Password Prompt When Changing Standard SQL Server Login

Something that I have identified recently at several sites is clients being prompted for password confirmation after changing a standard SQL Server login. This has been identified as a bug and can be corrected with the fix in the following KB article