Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL ERROR -‘MSDASQL’ was unable to begin a distributed transaction." › Re: SQL ERROR -‘MSDASQL’ was unable to begin a distributed transaction."
Hi Richard,
I get the following error when i do the dtc test.
Platform:Windows 2003
Windows 2003,sp1 environment is detected:
Reading MSDTC settings from local registry:
Security settings for DTC under Windows 2003
NetworkDtcAccess :true
NetworkDtcAccessAdmin :true
NetworkDtcAccessClients :false
NetworkDtcAccessTransactions:true
NetworkDtcAccessTip :false
XaTransactions :true
AccountName :NT Authority\NetworkService
NetworkDtcAccessOutbound :true
TurnOffRpcSecurity :true
FallbackToUnsecureRPCIfNecessary:false
AllowOnlySecureRpcCalls :false
IP Configure Information
Host Name . . . . . . . . . : power1
DNS Servers . . . . . . . . :
Node Type . . . . . . . . . :
NetBIOS Scope ID. . . . . . :
IP Routing Enabled. . . . . : no
WINS Proxy Enabled. . . . . : yes
NetBIOS Resolution Uses DNS : no
Ethernet adapter {F7DF68EE-81B6-4E20-8B18-BD145CF2C796}:
Description . . . . . . . . : Intel(R) PRO/1000 F Server Adapter
Physical Address. . . . . . : 00-0E-0C-84-45-32
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . :
Subnet Mask . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . :
DHCP Server . . . . . . . . : 255.255.255.255
Primary WINS Server . . . . : 0.0.0.0
Secondary WINS Server . . . : 0.0.0.0
Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970
Ethernet adapter {1CDD80C7-F2CF-49B9-8C61-EEDF58BFCF65}:
Description . . . . . . . . : Intel(R) PRO/1000 MT Dual Port Network Connection #2
Physical Address. . . . . . : 00-04-23-B3-9F-81
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . :
Subnet Mask . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . :
DHCP Server . . . . . . . . : 255.255.255.255
Primary WINS Server . . . . : 0.0.0.0
Secondary WINS Server . . . : 0.0.0.0
Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970
++++++++++++lmhosts.sam++++++++++++
++++++++++++hosts ++++++++++++
127.0.0.1 localhost
++++++++++++++++++++++++++++++++++++++++++++++
DTCping 1.9 Report for POWER1
++++++++++++++++++++++++++++++++++++++++++++++
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
12-07, 10:37:18.142–>Start DTC connection test
Name Resolution:
xeonsql–>192.168.124.254–>XEONSQL
12-07, 10:37:19.673–>Start RPC test (POWER1–>xeonsql)
Problem:fail to invoke remote RPC method
Error(0x6D9) at dtcping.cpp @303
–>RPC pinging exception
–>1753(There are no more endpoints available from the endpoint mapper.)
RPC test failed
Please help, many thanks