Quicky Identify the ADFS Database Type

The provided PowerShell command can be used to efficiently determine the database type employed by your ADFS farm.

$ADFSDBInfo = gwmi -Namespace root/ADFS -Class SecurityTokenService
$ADFSDBInfo

In the case of Windows Internal Database (WID), the database connection string will typically include ‘##wid’ as an indication that the farm is using WID as the database.

Conversely, for SQL Database, the connection string may include a field related to ‘SQL‘, although the exact field name depends on the specific SQL database you have input.