Use Secure4

 --select Password,  *
 --from membership.Users
 --where UserName = 'KrisT'


 delete pw
 from membership.PasswordHistory pw
 join membership.Users u
 on pw.UserId = u.UserID
 where u.UserName = 'KrisT'

 update membership.Users
 set Password = 'GbsWQQoAL23z1gmvH9M45yFBHrGVAiMNUri1gNhxNxt6FE/S0fc='  --83r51at7187@B14
 ,ChangePassword = 0
 ,LastPasswordReset = GETDATE()
 ,Locked = 0
 where UserName = 'KrisT'