After restoring a database on a different server than the one it is coming from, it will contain orphaned users. Here is how to find these orphaned users: exec sp_change_users_login ‘report’ In order to fix this, the logins for the reported users will have to be created on the new server if they do not […]