Book Image

Active Directory Administration Cookbook - Second Edition

By : Sander Berkouwer
Book Image

Active Directory Administration Cookbook - Second Edition

By: Sander Berkouwer

Overview of this book

Updated to the Windows Server 2022, this second edition covers effective recipes for Active Directory administration that will help you leverage AD's capabilities for automating network, security, and access management tasks in the Windows infrastructure. Starting with a detailed focus on forests, domains, trusts, schemas, and partitions, this book will help you manage domain controllers, organizational units, and default containers. You'll then explore Active Directory sites management as well as identify and solve replication problems. As you progress, you'll work through recipes that show you how to manage your AD domains as well as user and group objects and computer accounts, expiring group memberships, and Group Managed Service Accounts (gMSAs) with PowerShell. Once you've covered DNS and certificates, you'll work with Group Policy and then focus on federation and security before advancing to Azure Active Directory and how to integrate on-premise Active Directory with Azure AD. Finally, you'll discover how Microsoft Azure AD Connect synchronization works and how to harden Azure AD. By the end of this AD book, you’ll be able to make the most of Active Directory and Azure AD Connect.
Table of Contents (18 chapters)

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