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.
