run this command

sp_change_users_login 'report'

if the user lists in the output then run the following given below

sp_change_users_login 'update_one','username','username'

this should ix your problem.