SQL Server: Orphaned Users

Two questions that sometime come up in discussion forums as well as at client sites are related to Orphaned Sessions (Oracle, SQL Server, DB2 LUW) and Orphaned Users (SQL Server). In this post, we are going to talk about the later one. Before we start talking about orphaned users and how to detect and resolve the issue, it is important to understand how the Authentication/Authorization process works in SQL Server. We are not going to cover the user-schema separation in this post - you can read more on that here.

Read More >>