Re: SQL ERROR -‘MSDASQL’ was unable to begin a distributed transaction."

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."

#16766

Hi Richard,

This is the error i am receiving. Please help!

 

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

Many thanks