As anyone faced this issue with connecting FNMS to a ILMT SQL instance, and what the problem might be:
Inventory gathering failed. Error: Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=14650; handshake=13508; There is a possible connection type mismatch: check that the database is of the correct connection type
Dec 04, 2019 02:19 PM
Tips given in the following StackOverflow thread may help with this one: Connection to SQL Server Works Sometimes. Responses there suggest that some changes to the network configuration on the SQL Server instance hosting the ILMT database may be required to allow the connection you are trying to make.
Dec 04, 2019 09:14 PM