Configuring Microsoft SQL Server for Distributed Transactions
Configuring Microsoft SQL Server for Distributed Transactions
Before you start Microsoft SQL Server, ensure that you configure it for distributed transactions. The
MDM Hub
requires a distributed transaction environment.
To ensure that the Microsoft Distributed Transaction Coordinator (MS DTC) service starts when you start Microsoft SQL Server, mark MS DTC as Automatic in the Service Manager.
Enable MS DTC for XA transactions.
Enable MS DTC for SNA LU 6.2 transactions.
Configure the JDBC distributed transactions component.
Download and extract the supported version of the Microsoft SQL Server JDBC driver from the Microsoft website to a directory on the machine.
Copy the
sqljdbc_xa.dll
file to the
Binn
directory of the machine on which Microsoft SQL Server is installed.
Run the
xa_install.sql
script on the Microsoft SQL Server instance as an administrator.
The
xa_install.sql
script is in the
xa
directory of the JDBC driver.
Verify that the script creates the SqlJDBCXAUser role in the Microsoft SQL Server master database.
For more information about how to install and configure Microsoft SQL Server for distributed transactions, see the Microsoft SQL Server documentation.