SQL Server 2019 XA transactions

The following error in the ImageMaster logs indicates an issue with the setup of the SQL Server JDBC XA transactions component:

Could not load the DLL SQLJDBC_XA.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found).

ImageMaster requires a specific SQL Server component that provides JDBC XA transaction capability, which is installed by executing a stored procedure. Sometimes it was observed that executing the stored procedure is not enough and the above error still occurs. In such a scenario, copy the required driver file into the expected location according to “SQL Server – enabling the JDBC distributed transaction components by copying the DLL” in section Installation of needed components in [IG SQL Server].