2 queries to find and fix orphan users on a SQL Server Database…

sp_change_users_login

Displays which users have no login name mapped to them
sp_change_users_login ‘Report’

Update an orphan username
sp_change_users_login ‘Update_One’, ‘username’, ‘login_username’

Enjoy!