• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 625
  • Last Modified:

Network DTC Access

Does anybody know of any reason why we shouldn't enable Network DTC Access on our SQL 2008 cluster?  One of our vendors, Connecsys, has a web app that requires it.  It's been run from a separate DB up to now, but we're trying to consolidate all DBs to the cluster and came across this issue.  I just want to be sure we're not opening up a can of worms here.
1 Solution
Per KB: 817064

When you do not enable network DTC access on the server, applications can only use transactions that stay on the local computer. For example, transactions cannot flow from a local computer to a database that runs on a separate computer if network DTC access is disabled.

Also, this link might help from msdn:

Configure DTC for SQL 2008 - MSDN
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now