Question

When adding an additional Federation Server in an environment utilizing SQL databases as opposed to WID, what three pieces of information must be provided?

a) Federation server's IP, SQL server name, and database name
b) SQL server's IP, database name, and port number
c) Federation server's certificate thumbprint, SQL server name, and database name
d) SQL server's instance name, database name, and SQL login credentials

Answer 1

Adding an additional Federation Server with a SQL database requires the SQL server's instance name, the database name, and the SQL login credentials. These details enable the server to connect to the database that contains the federation configuration data.

Step-by-step explanation:

When adding an additional Federation Server in an environment that utilizes SQL databases as opposed to Windows Internal Database (WID), there are specific pieces of information that you need to provide for successful configuration. These pieces of information are critical for the Federation Service to communicate with the SQL database, which stores the configuration data for the Active Directory Federation Services (AD FS).

The three pieces of information required are:

1. SQL server's instance name: This is the name or network address of the instance of SQL Server to which you will be connecting.
2. Database name: The specific database within the SQL Server that holds the AD FS configuration data.
3. SQL login credentials: This includes the username and password that have the necessary permissions to access and modify the database.

It's imperative to have these details correctly configured so that the additional Federation Server can join the existing federation service and perform its role within the infrastructure effectively.