System Administration

Page tree

Versions Compared

Old Version 5

changes.mady.by.user user-ac987

Saved on

compared with

New Version 6

changes.mady.by.user Unknown User (bridget)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Anchor
enablingmsdtcforxa
enablingmsdtcforxa
Enable MS DTC for XA transactions

In Windows Vista, Windows 7, Windows 10, Windows Server 2008 R2 or Windows Server 2012 or later:

  1. Select Control Panel > Administrative Tools > Component Services.
  2. In Component Services, double click Computers, double click My Computer  and select Distributed Transaction Coordinator. 
  3. Right-click Local DTC and then select Properties.
  4. Click the Security tab in the Local DTC Properties window.
  5. Select the Enable XA Transactions check box, click OK. This will restart the MS DTC service.
  6. Click OK again to close the Properties window, and then close Component Services.
  7. Restart SQL Server to ensure that it syncs up with the MS DTC changes.

...