Archive for category SQL Server
Troubleshooting Orphaned Users (users not linked after restore DB in SQL server)
Posted by Jeffrey in SQL Server on March 17, 2009
After restoring a backup in SQL server you can have the problem that the users of you database are not linked anymore to the users of the database.This problem can be solved by running the command: sp_change_users_login ‘update_one’, ‘DBUser’, ‘DBUser’
To see all users that are not linked: go sp_change_users_login ‘report’
More information can be found in the article:
http://support.microsoft.com/kb/q274188/