Fix Orphan User

--Fix Orphan Users

EXEC sp_change_users_login 'Report'

EXEC sp_change_users_login 'Auto_Fix', 'user'

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

--Manual change the user account to link with specific login.

USE database name

go

EXEC sp_change_users_login 'Update_One', 'user', 'login'