Resolving orphaned user issues with SQL Server databases

Use   database name go -- orphaned accounts created with sp_change_users_login repair-- List Orphaned users of the current database exec sp_change_users_login ' report '-- You can automatically add a login with the same name that corresponds to the user name to the syslogins exec sp_change_users_login ' Auto_Fix ',' User name '-- maps the user name to the specified login name.  exec sp_change_users_login ' Update_One ',' User name ',' Login name '

Resolving orphaned user issues with SQL Server databases