Replication and Availability Groups with per database DTC support
In SQL Server 2017, when using Availability Groups with Per-Database DTC Support enabled, you are unable to configure replication.
The error received is:
Msg 3933, Level 16, State 1
Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction.
By design, per db DTC support does not allow save points. However, Replication system stored procedures make extensive use of save points. As a result, this creates a conflict where you cannot have a database in an AG with both Replication and per DB DTC support.
As a workaround, you must disable per DB DTC support in order to configure (or change configuration) of Replication.
James Eckhardt commented
Same issue. culminates in stored procs raising the error: "The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION"
...SQL 2016 SP2 running as a multi-subnet fail-over cluster.
Mike Leaman commented
Please fix this. AGs need to fully support replication.
On SQL 2016 SP2 - CU2 the problem still exists, disabling "per database DTC support" fixed the issue, waiting for the fix in next CU patch release.
On SQL 2016, this is an issue, after removing option 'Per Database DTC Support' this issue was resolved. FIX IT !!!!!!!
Same problem on SQL Server 2016 SP2 - CU1
Waiting for the bug fix
Sydney Croud commented
This also affected me when I had CDC on along with HA, as CDC is categorized as replication
jamie hutchings commented
Andy is correct, this needs to be fixed. Ran into this issue yesterday and only way to resolve was disabling per DTC support. Please fix.