Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

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.

86 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andy Mallon shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    7 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • James Eckhardt commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        On SQL 2016, this is an issue, after removing option 'Per Database DTC Support' this issue was resolved. FIX IT !!!!!!!

      • jamie hutchings commented  ·   ·  Flag as inappropriate

        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.

      Feedback and Knowledge Base