• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 637
  • 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.
0
s31064-2574
Asked:
s31064-2574
1 Solution
 
backhaulCommented:
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
0
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

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

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