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)

Migrating a WID-based AD FS farm to an SQL Server

This recipe shows how to migrate a WID-based AD FS farm to an SQL Server.

Getting ready

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 account that has these specific permissions:

  • Domain administrator privileges in Active Directory through membership of the Domain Admins group
  • Local administrator privileges on the primary AD FS server in the AD FS farm
  • sa privileges on the SQL server

How to do it...

To migrate a WID-based AD FS farm to the SQL Server, perform the following steps on the primary AD FS server:

  1. Create a script.
  2. Create AD FS databases.
  3. Detach databases from the AD FS server.
  4. Copy database files.
  5. Attach databases to the SQL server.
  6. Reconfigure AD FS.
  7. Remove the WID feature.

Then, perform Steps 2, 5, and 6 for all other...