Logins
Generally, every principal granted security to SQL Server must have an associated login. The login provides access to SQL Server and can be associated with principals scoped at the Windows and server levels. These logins can be associated with Windows accounts, Windows groups, or SQL Server logins.
Note
Contained databases and their related users were introduced in SQL Server 2012. The users associated with a contained database do not have to have an associated login. This supports the principal behind a contained database which is to keep all elements of the database scoped at the database level. All references, including logins, which are outside the scope of the database, are removed. The users associated with a contained database ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
