Home Forums SQL Server 7,2000 Backups Can't access data from database restored from backup if not sysadmin RE: Can't access data from database restored from backup if not sysadmin

  • Even if you had the same user name on that new instance, the mapping to the database might not be correct as it's by SID, not name. You can use sp_change_users_login to find orphaned users and re-sync them.