From the course: Microsoft SQL Server 2016 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Overview of authentication in SQL Server - SQL Server Tutorial
From the course: Microsoft SQL Server 2016 Essential Training
Overview of authentication in SQL Server
- [Instructor] In this section, we're going to talk about Authentication in SQL Server 2016. We have two options on how to handle Authentication. The first option is called Windows Authentication, and the second is called SQL Authentication. We'll talk a little bit about each of these. With Windows Authentication, the usernames and passwords are stored in Active Directory. This provides a seamless login for users, so users will go to their workstation in the morning, type in their Windows username and password, and then when they want to access SQL Server, it will be the same username and password, and therefore that information would just be automatically transferred to SQL Server. The user won't have to type in a new password. With this Authentication model, users are managed primarily by domain administrators. So, the same people that manage usernames and passwords throughout the domain, would continue to handle this responsibility even as it applies to SQL Server. The other…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.