• ALZDBA (3/21/2012)


    To help out a bit more I've added a Powershell (2.0) script that I created at the time I installed my n-th instance.

    We provide an MSDTC-resource with each individual SQLInstance on a cluster.

    Apologies for digging up a thread from last year. However, I had found an article located here with similar code that is changing the settings in the registry, but if I go into Component Services and look at the properties of the clustered DTC, for whatever reason, Allow Inbound / Allow Outbound won't show checked off. However, the values are set to 1 in the appropriate HKLM\Cluster\Resources\<guid>\MSDTCPRIVATE\MSDTC\Security\ key.

    NetworkDtcAccessInbound 1

    NetworkDtcAccessOutbound 1

    After setting the values with powershell, I'm stopping and starting the resource in the cluster via powershell as well to ensure the changes take effect.

    With the registry values set, is that sufficient to assume the setting is in effect or would it be best to confirm that the GUI updates as well to be safe? Any thought as to what I'm missing?

    Thanks in advance,

    Steve