Solved

Network DTC Access

Posted on 2012-04-11
1
553 Views
Last Modified: 2012-04-16
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
Comment
Question by:s31064-2574
1 Comment
 
LVL 1

Accepted Solution

by:
backhaul earned 500 total points
ID: 37833469
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

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now