This isn’t the first time I’ve had to deal with orphaned users in SQL Server, and probably won’t be the last but today I found myself investigating why it happens and how to resolve the issue it causes. I guess before I start on that I should explain what an orphaned user is.