Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to use the SQLNCLI 10 driver to set up a Linked Server to a legacy SQL Server 2000 instance on our network.

I understand you cannot use Version 11 as it doesn't support SQL Server 2000 (running on Windows 2003 latest service packs). The SQL Server 2012 is on Windows 2008 x64.

I can create the conenction, and the databases and their schemas display, but when I try to execute a query I get:

Msg 8522, Level 16, State 3, Line 1 Microsoft Distributed Transaction Coordinator (MS DTC) has stopped this transaction.

Anyone seen this or know how to resolve it?

share|improve this question
Have you configured MS DTC on both servers? – mrdenny Mar 15 '12 at 2:02
Yes. I've tried altering the security settings - no joy – WOPR Mar 15 '12 at 2:13
Can you run a simple transaction as a distributed transaction? – mrdenny Mar 15 '12 at 2:27
This appears to be a bug in the new version of the driver. You need to wrap the call in an explicit transaction to work around it. – WOPR Mar 18 '12 at 8:04
Be sure to submit the feedback to Microsoft via so that they can address the problem. – mrdenny Mar 18 '12 at 8:39

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.