If you do a db backup and then a restore to another server the users are usually screwed up. And you can't just readd them as it says the users doesn't exist. However it works now
Use dbname
go
sp_change_users_login 'update_one', 'sourceuser', 'destuser'
|