OLE DB x Linked server
Napsal: 04.03.2024 16:01Při práci s linked serverem se může objevit tato chyba:
The operation could not be performed because ole db provider "msoledbsql" for linked server was unable to begin a distributed transaction.
Řešení:
The operation could not be performed because ole db provider "msoledbsql" for linked server was unable to begin a distributed transaction.
- 0ompserv.png.png (92.04 KiB) Zobrazeno 1152 krát
Řešení:
- Povolení MS Distributed Transaction Coordinator na Windows Server 2022
- Windows Administrative Tools / Component Services / Computers / Distributed Transaction Coordinator / Local DTC - pravé tlačítko Properties
- záložka Security - Povolit Network DTC Access, Allow Inbound, Allow Outbound, No Autetication Required, Enable XAA Transactions
- Dále ve Windows Defender Firewall povolit Distributed Transaction Coordinator
- 1compserv.png (97.42 KiB) Zobrazeno 1152 krát
- 2ompserv.png (112.02 KiB) Zobrazeno 1152 krát
- 3ompserv.png (134.77 KiB) Zobrazeno 1152 krát
- 4ompserv.png (39.73 KiB) Zobrazeno 1152 krát