From the course: SQL Server 2014 Essential Training
Unlock the full course today
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: SQL Server 2014 Essential Training
Overview of authentication in SQL Server
- In this section, we're gonna talk about Authentication in SQL Server 2014. Authentication is another way to say how do you log in, what type of account do you have? SQL Server supports two different types of accounts. The first type is Windows Logins, and the other is SQL Server Logins. With the Windows Login, the username and password is stored by the Windows operating system. So these are the same type of accounts you use to log in to a workstation, or a server. We can tie SQL server permissions to an individual Windows login, or to a Windows group, like the group of administrators. With SQL Server Logins, the username and passwords are stored in SQL Server. The passwords are encrypted, and I'll say extremely difficult to unencrypt. Don't want to say anything is impossible, but for all practical purposes, it is impossible to unencrypt these passwords. An administrator can change any user's password, but they can't go in and look at the password. These logins will only give you…
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.