Orphan User: NO login id or password is not associated
With user.
exec sp_change_users_login 'Report' (It helps to find the
orphan user)
Exec sp_change_user_login 'auto_fix','loginname',null(It
helps to map the user with login)
exec sp_change_users_login 'Report'
Running the following query on destination server where
database as been moved to list orphan user
No comments:
Post a Comment