You're reading from Active Directory Administration Cookbook, Second Edition Proven solutions to everyday identity and authentication challenges for both on-premises and the cloud

Product type Paperback

Published in Jul 2022

Publisher Packt

ISBN-13 9781803242507

Length 696 pages

Edition 2nd Edition

Languages

PowerShell

Tools

Azure

Concepts

Identity Management

Author (1):

Sander Berkouwer

View More author details

Table of Contents (18) Chapters

Preface

1. Chapter 1: Optimizing Forests, Domains, and Trusts

2. Chapter 2: Managing Domain Controllers FREE CHAPTER

3. Chapter 3: Managing Active Directory Roles and Features

4. Chapter 4: Managing Containers and Organizational Units

5. Chapter 5: Managing Active Directory Sites and Troubleshooting Replication

6. Chapter 6: Managing Active Directory Users

7. Chapter 7: Managing Active Directory Groups

8. Chapter 8: Managing Active Directory Computers

9. Chapter 9: Managing DNS

10. Chapter 10: Getting the Most Out of Group Policy

11. Chapter 11: Securing Active Directory

12. Chapter 12: Managing Certificates

13. Chapter 13: Managing Federation

14. Chapter 14: Handling Authentication in a Hybrid World (AD FS, PHS, PTA, and DSSO)

15. Chapter 15: Handling Synchronization in a Hybrid World (Azure AD Connect)

16. Chapter 16: Hardening Azure AD

17. Other Books You May Enjoy

Setting up an AD FS farm with SQL Server

In this recipe, you learn how to set up an AD FS farm with a SQL Server-based backend. This is Step 2 of setting up an AD FS farm and an alternative to the steps described in the Setting up an AD FS farm with WID recipe.

Getting ready

In the organization, ensure that there is a consensus on the name of the AD FS farm.

Ensure a TLS certificate is available for the AD FS farm name, or request one from a CA. Install the certificate in the Personal certificate store for the local machine.

To set up an AD FS farm, ensure that a domain-joined Windows Server installation is available to commission as an AD FS server and has the AD FS server role installed. Additionally, ensure the AD FS farm name is resolvable to this server in the appropriate DNS zones.

Have a domain-joined SQL server available on the network that is also resolvable through DNS and reachable by the proposed AD FS server(s).

Perform all the following steps with an...