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
Steve Jones - SSC Editor
SSC Guru
Points: 734498
More actions
July 30, 2009 at 8:45 am
#1032428
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.