Tail log backup query in log shipping reversal
If I had to make a guess your database is just fine, but you never created the server principals (logins) associated with the database principals (users) in your database.  It's deprecated but try this and see if you get a result.

EXEC sp_change_users_login 'report'


You can also try this piece of code:

USE dbname;
SELECT logins.name as logins, users.name as users, users.type_desc
FROM sys.database_principals users
LEFT OUTER JOIN sys.server_principals logins
    ON users.sid = logins.sid
WHERE users.type IN ('U','S','G')


If there are any NULLs in the logins column then that's probably your problem.  Create the login (if it's a SQL ID then make sure you specify the correct SID).