Query to reset the password of the user.
 
UPDATE userreg SET status=1,  passwordexpired=0,
logonpassword= (SELECT logonpassword FROM userreg WHERE logonid='wcsadmin'),
salt= (SELECT salt FROM userreg WHERE logonid='wcsadmin')
where logonId=< logonid of user being reset >