When restoring a database from a .bak file, destroy and recreate the users.

That is the way to get around this problem.