Chapter 18

Authentication and Encryption

TOPICS COVERED IN THIS CHAPTER:

  • Understanding Authentication
  • SQL Server Authentication Methods
  • Logins, Users, and Roles
  • Encryption

image Two important components of security are authentication and confidentiality, which are accomplished through the use of encryption in data storage. Authentication helps to prove the identity of a user or system, and encryption helps to protect data and prevent unauthorized users from accessing or viewing it. This chapter will address authentication as a concept and how it is implemented in SQL Server specifically. Then it will turn to encryption, first addressing the concept ...

Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond 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.