Restore A SQL User After a SQL Database Restore

Find missing users:

EXEC sp_change_users_login 'Report'

Create the user if it does not exist:

CREATE LOGIN 'UserName' WITH PASSWORD= 'password' 

Restore the user:

EXEC sp_change_users_login 'Update_One', 'UserName', 'UserName'