I have worked with SQL Server for many years now, back to Sybase SQL Server days and there has always been confusion over Logins and Users. Even though they typically use the same name they are separate objects. Newcomers to SQL Server always seem to confuse the two. Let's take a look...
The article continues at