This chapter includes instructions for setting up SQL Server to allow XA transactions. The steps described below are essential for ImageMaster to be able to properly connect to SQL Server through JDBC. For more details on XA Transactions see [XA Transactions]. XA distributed transaction connections default to the “Read Committed” isolation level. Note that the Windows Administrator privileges rights are required for the following configuration steps.
The JDBC distributed transaction components are included in the “xa” directory of the JDBC driver installation. These components include the “xa_install.sql” and “sqljdbc_xa.dll” files. The JDBC driver is available for download from the public sources [SQL Server JDBC Driver].
For this step, use the JDBC driver package from Microsoft in the version corresponding to the version of the provided ImageMaster Edition of the JDBC driver. The original JDBC driver package corresponds to the ImageMaster Edition JDBC driver when the first three segments of the version number are the same (i. e. for the ImageMaster Edition of the JDBC driver version 12.2.0.2 the corresponding JDBC driver package from Microsoft should be in version 12.2.0).
Follow the instructions depending on your SQL server version either for SQL Server 2019 or SQL Server 2017.