How to fix orphaned database users:
ALTER USER Username WITH LOGIN = LoginName
Commonly happens when you backup then restore a database to a different SQL server. Any users in the database are orphaned even thought a matching login exists on the new server. The problem is that the SID of the login and the database user does not match. Alter User ... can fix this.
Reference:
http://sqlsolace.blogspot.com/2011/05/alter-user-with-login-to-fix-orphaned.html
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment