I kept getting a SQL Server error 15063, “This login already has an account under a different username”, when trying to add an Active Directory account as a user in a particular database. I didn’t realize it, but a previous admin had mapped the dbo username to that login. Strange. To find the offending account, I opened a new query window and ran:
Hope this can help someone out.