SQLTeam.com | Weblogs | Forums

Enabling per Database DTC Support for an existing Availability group


#1

Hi,

I have 'inherited' an SQL 2016 server with an availability group (AG) set up on it.

Developers have requested that one of the databases is set up to allow DTC access to it.

The AG does not have Per Database DTC support selected for it. I have tried seleting this on the primary server AG properties screen, as the field is not greyed out, but when i go back into the screen the flag is unset.

Is there a way of setting this?