Can be a problem if you restored from other server or re-created after you took backup.

Try to find if its an Orphan

-- Find orphaned users

USE

GO

sp_change_users_login @Action='Report'

GO

-- Fix orphaned...