did you use sp_help_revlogin to transfer the new ID?

what are the results when you run

exec sp_helpuser

and

exec sp_change_users_login 'report'

in the secondary database

if you added the user in the primary database and have restored a log backup post that action on the secondary, it will be there.