Reputation: 151
According to the documentation, it should "just work," but it doesn't.
I have a newly built Ubuntu 22.04 minimal server with SQL Server for Linux 2022 installed. I followed the instructions from the MS website to install the SQL Server and to configure the MSDTC. The installation appeared to go very smoothly.
I can access the database just fine and have copied a development database from a Windows SQL server to the Linux, again no issues.
However, my application, which is a .NET 4.8 WinForms application using ADO.NET SQL client, can perform local transactions, but when a transaction is upgraded to a distributed transaction, it fails.
The message I receive is the standard
The MSDTC transaction manager was unable to pull the transaction from the source transaction manager due to communication problems. Possible causes are: a firewall is present and it doesn't have an exception for the MSDTC process, the two machines cannot find each other by their NetBIOS names, or the support for network transactions is not enabled for one of the two transaction managers. (Exception from HRESULT: 0x8004D02B): Query: (StartDate <= 11/06/2024 00:00:00 AND EndDate >= 11/06/2024 00:00:00)
I have checked the computer can ping each other using their names.
I have completely disabled the firewalls at both ends.
MSDTC is configured on the workstation, as it still works fine on the remote Windows SQL Server.
I have been trying different options, but I always receive this error.
Can anyone help point me in the right direction to find why this is not working?
Upvotes: 0
Views: 61