Chapter 22

Authentication and Granular Access

Introduction

Authentication is a key concept in SQL Server. In this chapter we’ll look at the two authentication modes SQL Server supports. In addition, we’ll cover all the methods for authentication in this chapter. Finally, we’ll take a look at granular access and how you can use this feature to further secure your SQL Server. By the end of this chapter, you will have a good understanding of the following concepts:

 SQL Server Authentication ...

Get The Best Damn Exchange, SQL and IIS Book Period now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.