Join Adam Wilbert for an in-depth discussion in this video Understanding Windows authentication, part of Database Foundations: Administration.
- When it comes to identifying users, we can let the Windows operating system handle the process so that the server itself doesn't have to. This is called Windows Authentication. Windows Authentication is typically considered to be a superior method for authenticating users, since users won't need to remember additional usernames or passwords, and because it's better integrated with the security model used throughout an organization's network. In order to gain access to the server, users must have a valid Windows account. The Windows Security Identifier, or SID, is passed to the SQL Server and verified against a list of registered user accounts.
This works for individual user accounts, as well as members of a group account. When a Windows user group is accepted as a SQL Server login, any Windows user that is a member of that group will be authenticated by SQL Server. Access, roles, and permissions can be assigned to the Windows user group, and they will automatically apply to any users within that group.
Note: This course will also prepare certification candidates for the "Administer a database" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals.
- Securing the database server
- Understanding Windows authentication vs. SQL Server authentication
- Assigning fixed server roles and fixed database roles
- Granting object-level permissions
- Understanding ownership claims
- Creating backups
- Restoring a database