Configure WSFC Clustered MSDTC Via PowerShell 3.0


Overview:

This document will discuss the steps to configure and change a clustered MSDTC instance on a Windows Server 2012 Failover Cluster [WSFC] using PowerShell 3.0.  This document does not describe the steps to install a clustered MSDTC instance.

NOTE:  The steps below are run from a remote Windows Server 2012 administrative server with the necessary firewall access to administrate a WSFC and its node.  As an alternative you may run PowerShell on the hosts locally.

Query WSFC Clustered MSDTC Settings:

1.     From the Start window run Windows Powershell as administrator.

2.     Enter a remote PowerShell session to the host using the fully qualified domain name [FQDN].
Enter-PSSession <HOST>.<DOMAIN>

3.  Query the current network settings for the clustered MSDTC instance.
Get-DtcNetworkSetting –DtcName <DTC_NAME>
Sample Output:
AuthenticationLevel               : Mutual
InboundTransactionsEnabled        : False
OutboundTransactionsEnabled       : False
RemoteClientAccessEnabled         : False
RemoteAdministrationAccessEnabled : False
XATransactionsEnabled             : False
LUTransactionsEnabled             : False

4.     Modify the settings above for the clustered MSDTC instance.  You will be asked to confirm the action.
Example:
Set-DtcNetworkSetting –DtcName <DTC_NAME> -InboundTransactionsEnabled 1 –OutboundTransactionsEnabled 1 –RemoteClientAccessEnabled 1 –RemoteAdministrationAccessEnabled 1 –XATransactionsEnabled 0 –LUTransactionsEnabled 1

5.  Query and verify the network settings for the clustered MSDTC instance.
Get-DtcNetworkSetting –DtcName <DTC_NAME>
Sample Output:
AuthenticationLevel               : Mutual
InboundTransactionsEnabled        : True
OutboundTransactionsEnabled       : True
RemoteClientAccessEnabled         : True
RemoteAdministrationAccessEnabled : True
XATransactionsEnabled             : False
LUTransactionsEnabled             : True

Set Default WSFC Clustered MSDTC:

In a multi-subnet WSFC environment you can create multiple MSDTC instances, one per subnet, but only 1 instance can be the default.  Use the commands below to change the default clustered instance.
Note:  This would be executed as part of a WSFC multi-subnet failover.

1.     From the Start window run Windows Powershell as administrator.

2.     Enter a remote PowerShell session to host using the FQDN.
Enter-PSSession <HOST>.<DOMAIN>

3.     Query to identify the clustered MSDTC instance.
Get-DtcClusterDefault

4.     Set the name of the correct clustered MSDTC instance.
Example:
Set- DtcClusterDefault –DtcResourceNameName <DTC_NAME>

5.     Query and verify the network settings for the clustered MSDTC instance.
Get-DtcClusterDefault

Comments

Popular posts from this blog

Windows Server Failover Clustering/SQL Server Firewall Access Rules

Windows Server Recommendations For AWS

Requirements for SQL Server AlwaysOn Feature on a Windows Server Failover Cluster