Kevin Hill explains that there are two wolves inside your SQL Server:
“We added them to the database, but they still can’t connect.”
Sound familiar? That’s the kind of confusion SQL Server’s two-layer security model creates when people don’t understand the difference between a login and a user.
Let’s clear that up, because getting it wrong causes broken access, orphaned users, and frustrated help desk calls.
Click through for Kevin’s explanation.