It sounds related to a mismatched SID between the Server Login and Database User. By any chance was the database in question restored to this server from a backup taken from a different server?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato