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:

sp_helplogins 'domain\account'

Hope this can help someone out.