Script to Fix Orphan Users in SQL Server

--Find Orphan Users in the DB

EXEC sp_change_users_login 'Report'

--If you already have a login created, map the user to login using the following script.

EXEC sp_change_users_login 'Auto_Fix', 'user'

--If you want to create a new login and password for this user, fix it by doing:

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

--get info about what AD groups the user is associated with.

xp_logininfo 'Domain\UserName','all'