When trying to move our Alloy db from SQL 2000 to SQL 2005, we are having user problems. The main technician that generally makes all the changes seems to be missing from the db users list. Below are the steps used to recreate the problem.

Detach db from SQL 2000.
Copy files to new server.
Attach db to SQL 2005.
User missing. Cannot log in to Alloy with this user.

I have tried the command 'sp_change_users_login report', but it does not report the user in question. It reports every other user and I am able to log in with them.

I got the logins populated correctly now and all users are able to log in to the database on the new server now. However, when I try to edit any user information in the Administrative Settings, I receive the message "User does not have permission to perform this action". I am a member of the "Administrator Role". We have tried this with multiple logins with the same effects.