Here are some notes regarding Oprhaned Users:

-- Check for Orphaned Users for database .

USE ;

sp_change_users_login 'report';

-- If you already have a login id and password for this user,

-- fix it by doing:

EXEC sp_change_users_login 'Auto_Fix', 'user'

-- If you want to create a new login id and password for

-- this user, fix it by doing:

EXEC sp_change_users_login 'Auto_Fix', 'user', 'login', 'password'

Happy T-SQLing.