Thank you for your post!
I believe the Certificate issue you are experiencing are due to the concatenation mentioned in your previous post (FileMaker server 16 upgrade issues ). Following the steps in Configuring security for FileMaker Server 15 and higher should resolve this for you.
Are you receiving this failure when configuring the DSN?
You do want to be sure you are using the correct bit-version of the ODBC Administrative tool:
- The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
- The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.
Yes, the issue here was a missing intermediate file for the installation of the certificate. You need to make sure you have the domain certificate, private key, root/intermediate key and the password. This then solved my issue.