Why is upgrade or install to MFT version 3.8.0 failing when using remote Database?

Introduction:

This knowledge base article provides a solution to Failed to check SQL Server version error when installing or upgrading to version 3.8.0.

Details:

In the MFT version 3.8.0 the connection to a remote database can be failing due to an internal limitation of the MFT installer which is using an SA account to check the SQL version of the remote database rather than the provided SQL credentials.

The error will look as below:

This limitation has been resolved in the MFT version 3.8.1 and newer.

Please keep in mind that we do recommend installing the latest MFT versions at all times to avoid any issues and also have the latest features and security updates.