Do the following:

1- delete all user IDs that came from the restore

2- Look for sp_help_revlogin and run it on the source server

3- Copy the output and run it on the...

I am actually working on the same project with side-by-side 7 to 2005. Believe me, you have to have SP4 and all DBs need to be in 70 compatiblity mode.

Here is...