SQL Server 2008 Orphaned user workaround

Get a database backup from a single server. Restore to local, users in the database cannot log on, which is what the online help says about orphaned user issues that may arise from restoring a backup.

First, create a new MyDataBase database

Second, put the backup file in the C packing directory

Third, the SA connection database, select any library. , execute the following script

RESTORE DATABASE  from DISK = ' C:\MyDataBase.BAK '  with REPLACE Go

Iv. Selection MyDataBase Execute the following script

EXEC ' MyDataBase' database user name  ' sql SERVER login  '