Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
1  
Be sure to submit the feedback to Microsoft via connect.microsoft.com so that they can address the problem. –  mrdenny Mar 18 '12 at 8:39

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.