What are Orphaned Users? Here I’ll describe what an orphaned user is and how it happens. I’ll even show you how to produce the condition yourself. Orphaned users are a part of life in SQL Server so you’d better know how to recognize them and how to fix them. Here’s the code I used in the vid: