• I also have similar problem.

    Step 1.

    Create the file get_users_login.sql

    select 'exec sp_change_users_login ' + quotename('Update_One', char(39)) + ',' + quotename(sl.name, char(39)) + ',' + quotename(su.name, char(39)) + ';'

    from master.dbo.syslogins sl

    join dbo.sysusers su on sl.sid = su.sid

    where sl.hasaccess = 1

    and sl.isntname = 0

    and sl.name not in ('guest', 'dbo', 'sys', 'INFORMATION_SCHEMA')

    Step 2.

    osql get_users_login.sql -o fix_users_login.sql -w 2048 -n -h-1

    Step 3.

    Run osql fix_users_login.sql against any other server