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