MSDTC settings

I have read many times that MSDTC security settings should be consistent on both SQL servers and BizTalk servers. Most people tend to check everything in the security configuration dialog box. I finally stumbled on some recommendations on the settings, and they are as follows:
Network DTC Access – Enabled.
Allow Remote Clients – Disabled, unless using MQ Series.
Allow Remote Administrations – Disabled.
Allow Inbound – Enabled.
Allow Outbound – Enabled.
Mutual Authentication Required – Enabled if all remote machines are running Win2K3 SP1 or XP SP2 or higher.
Incoming Caller Authentication Required – Enabled if running MSDTC on a cluster.
No Authentication Required – Enabled if remote machines are pre-Windows Server 2003 SP1 or pre- Windows XP SP2.
Enable TIP – Enabled if running the BAM Portal.
Enable XA Transactions – Enabled if communicating with an XA based transactional system such as when communicating with IBM WebSphere MQ using the MQSeries adapter.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.