I recently got to duplicate / migrate a SQL Server 2008 database. I had trouble with the logins, which were broken after the move. It has to do with mismatching SID for DB users. To fix, one needs to select the database in question then exec sp_change_users_login 'Report' The procedure lists any […]