MSOLEDBSQL Provider Link Server Issues

%3CLINGO-SUB%20id%3D%22lingo-sub-294668%22%20slang%3D%22en-US%22%3EMSOLEDBSQL%20Provider%20Link%20Server%20Issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-294668%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI'm%20trying%20to%20create%20a%20link%20server%20with%20the%20new%20MSOLEDBSQL%20provider%2C%20to%20make%20use%20of%20the%20MULTISUBNETFAILOVER%20options%2C%20but%20all%20attempts%20to%20create%20one%20regardless%20of%20SQL%20Version%20results%20in%20%22Microsoft%20Distributed%20Transaction%20Coordinator%20(MS%20DTC)%20has%20stopped%20this%20transaction.%22%20errors.%26nbsp%3B%20Are%20there%20any%20fixes%20for%20this%3F%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I'm trying to create a link server with the new MSOLEDBSQL provider, to make use of the MULTISUBNETFAILOVER options, but all attempts to create one regardless of SQL Version results in "Microsoft Distributed Transaction Coordinator (MS DTC) has stopped this transaction." errors.  Are there any fixes for this? 

0 Replies