远程计算机的SQL适配器 [英] SQL Adapter for remote machine

问题描述

我正在为远程计算机上的数据库配置SQL适配器。我为此使用了SQL身份验证。我写了sql语句来选择带有for xml auto子句的数据，当下次命中时，得到以下错误;

"无法执行SQL statemnet，请确保提供的语法是正确的。新事务无法在指定的事务协调器中登记。

这与MSDTC问题有关吗？请回复该决议。

用户访问具有所有访问权限。

---

。Nilesh

Hi,

I'm configuring the SQL adapter for a database on the remote machine. I used SQL authentication for this. I wrote the sql statment to select the data with for xml auto clause, when hit next, getting folllowing error;

"Failed to execute the SQL statemnet, Please ensure that the supplied syntax is correct. New transaction can not enlist in specified transaction coordinator.

Is this something related to MSDTC issue/? Please reply the resolution.

User accessing has all the access rights.

---

.Nilesh

推荐答案

你可以尝试运行DTCPing
http：// www .microsoft.com / downloads / details.aspx？FamilyID = 5e325025-4dcd-4658-a549-1d549ac17644& DisplayLang = en
以协助DTC问题

You can try running DTCPing
http://www.microsoft.com/downloads/details.aspx?FamilyID=5e325025-4dcd-4658-a549-1d549ac17644&DisplayLang=en
to assist with DTC issues

这篇关于远程计算机的SQL适配器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！