It's a matter of having orphaned users.

I believe the user may have detached and attached a new database and affected the sysusers table.

see this article:

http://vyaskn.tripod.com/troubleshooting_orphan_users.htm