I had a same problem with SQL 2000 when I restored one of my DBs in different server which had same logins because of UIDS mismatch. But this can be easily solved with sp_change_users_login 'Update_One', 'user', 'login'.

Dinesh

mcp mcse mcsd mcdba