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 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.