DTCPing works, but distributed transaction cannot be started

Hi!
I'm getting an error when trying to start simple distributed
transaction.
Configuration is Win2k3/SQL2K <-> Win2k3 Cluster / SQL2K
[OLE/DB provider returned message: New transaction cannot enlist in the
specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].
DTCPing works in both directions, but there is one strange thing in log
on cluster server:
Cluster Environment detected
03-06, 06:52:43.296-->Invalid IP Address:207.x.x.253
(Mask:255.255.255.248) (38)
MSDTC Virtual Name:DTC1, IP:
When used internal an IP address, there is no such message.
Here is a full log of DTC ping on a cluster:
Platform:Windows 2003
cluster environment detected:
Windows 2003,sp1 environment is detected:
Reading MSDTC settings from cluster registry:
NetworkDtcAccess :true
NetworkDtcAccessAdmin :true
NetworkDtcAccessClients :true
NetworkDtcAccessTransactions:true
NetworkDtcAccessTip :false
XaTransactions :true
TurnOffRpcSecurity :true
NetworkDtcAccessOutbound :true
NetworkDtcAccessInbound :true
FallbackToUnsecureRPCIfNecessary:false
AllowOnlySecureRpcCalls :false
AccountName :NT AUTHORITY\NetworkService
IP Configure Information
Host Name . . . . . . . . . : HOSTA1
DNS Servers . . . . . . . . : 192.168.0.8
192.168.0.7
207.x.x.250
63.x.x.5
Node Type . . . . . . . . . :
NetBIOS Scope ID. . . . . . :
IP Routing Enabled. . . . . : no
WINS Proxy Enabled. . . . . : no
NetBIOS Resolution Uses DNS : no
Ethernet adapter {BBA542FC-1328-4246-A31B-16379406424B}:
Description . . . . . . . . : BASP Virtual Adapter
Physical Address. . . . . . : 00-10-18-14-4C-4E
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . : 192.168.0.103
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 192.168.0.101
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 192.168.0.100
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 192.168.0.105
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 192.168.0.107
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 192.168.0.8
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 {52ED9D48-488E-4265-AC55-3CE5BBFDBF23}:
Description . . . . . . . . : Broadcom NetXtreme Gigabit
Ethernet
Physical Address. . . . . . : 00-14-22-73-F9-C9
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . : 207.x.x.253
Subnet Mask . . . . . . . . : 255.255.255.248
IP Address. . . . . . . . . : 207.x.x.251
Subnet Mask . . . . . . . . : 255.255.255.248
IP Address. . . . . . . . . : 207.x.x.250
Subnet Mask . . . . . . . . : 255.255.255.248
Default Gateway . . . . . . : 207.x.x.249
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
193.x.x.147 HOSTB1
Cluster Environment detected
03-06, 06:52:43.296-->Invalid IP Address:207.x.x.253
(Mask:255.255.255.248) (38)
MSDTC Virtual Name:DTC1, IP:
++++++++++++++++++++++++++++++++++++++++++++++
DTCping 1.9 Report for
++++++++++++++++++++++++++++++++++++++++++++++
Firewall Port Settings:
Port:5000-5200
RPC server is ready
03-06, 06:52:51.078-->RPC server: received following information:
Network Name: HOSTA1
Source Port: 5069
Partner LOG: HOSTB15232.log
Partner CID: CA74E8B7-5274-40DF-97F0-CCF7B89895A9
++++++++++++Start Reverse Bind Test+++++++++++++
Received Bind call from HOSTB1
Network Name: HOSTA1
Source Port: 5069
Hosting Machine:
03-06, 06:52:51.296-->Trying to Reverse Bind to HOSTB1...
Test Guid:CA74E8B7-5274-40DF-97F0-CCF7B89895A9
Name Resolution:
HOSTB1-->193.x.x.147-->HOSTB1
Reverse Binding success: -->HOSTB1
++++++++++++Reverse Bind Test ENDED++++++++++
03-06, 06:52:52.296-->Called POKE from Partner:HOSTB1
Network Name: HOSTA1
Source Port: 5069
Hosting Machine:
++++++++++++Validating Remote Computer Name++++++++++++
03-06, 06:52:55.140-->Start DTC connection test
Name Resolution:
HOSTB1-->193.x.x.147-->HOSTB1
03-06, 06:52:55.156-->Start RPC test (-->HOSTB1)
RPC test is successful
Partner's CID:CA74E8B7-5274-40DF-97F0-CCF7B89895A9
++++++++++++RPC test completed+++++++++++++++
++++++++++++Start DTC Binding Test +++++++++++++
Trying Bind to HOSTB1
03-06, 06:52:55.296--> Initiating DTC Binding Test...
Test Guid:66C8FDED-CEC3-4C56-A4F6-F6EA236DAD5F
Received reverse bind call from HOSTB1
Network Name: HOSTA1
Source Port: 5069
Hosting Machine:
Binding success: -->HOSTB1
++++++++++++DTC Binding Test END+++++++++++++
Anyone can help me?
|||See if this helps.
HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server
2003
http://support.microsoft.com/kb/555017/en-us
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<maqdev@.gmail.com> wrote in message
news:1141651435.453798.152890@.u72g2000cwu.googlegr oups.com...
> Hi!
> I'm getting an error when trying to start simple distributed
> transaction.
> Configuration is Win2k3/SQL2K <-> Win2k3 Cluster / SQL2K
> ----
> [OLE/DB provider returned message: New transaction cannot enlist in the
> specified transaction coordinator. ]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
> ITransactionJoin::JoinTransaction returned 0x8004d00a].
> ----
> DTCPing works in both directions, but there is one strange thing in log
> on cluster server:
> ----
> Cluster Environment detected
> 03-06, 06:52:43.296-->Invalid IP Address:207.x.x.253
> (Mask:255.255.255.248) (38)
> MSDTC Virtual Name:DTC1, IP:
> ----
> When used internal an IP address, there is no such message.
> Here is a full log of DTC ping on a cluster:
> ----
> Platform:Windows 2003
> cluster environment detected:
> Windows 2003,sp1 environment is detected:
> Reading MSDTC settings from cluster registry:
> NetworkDtcAccess :true
> NetworkDtcAccessAdmin :true
> NetworkDtcAccessClients :true
> NetworkDtcAccessTransactions:true
> NetworkDtcAccessTip :false
> XaTransactions :true
> TurnOffRpcSecurity :true
> NetworkDtcAccessOutbound :true
> NetworkDtcAccessInbound :true
> FallbackToUnsecureRPCIfNecessary:false
> AllowOnlySecureRpcCalls :false
> AccountName :NT AUTHORITY\NetworkService
> IP Configure Information
> Host Name . . . . . . . . . : HOSTA1
> DNS Servers . . . . . . . . : 192.168.0.8
> 192.168.0.7
> 207.x.x.250
> 63.x.x.5
> Node Type . . . . . . . . . :
> NetBIOS Scope ID. . . . . . :
> IP Routing Enabled. . . . . : no
> WINS Proxy Enabled. . . . . : no
> NetBIOS Resolution Uses DNS : no
>
> Ethernet adapter {BBA542FC-1328-4246-A31B-16379406424B}:
> Description . . . . . . . . : BASP Virtual Adapter
> Physical Address. . . . . . : 00-10-18-14-4C-4E
> DHCP Enabled. . . . . . . . : no
> IP Address. . . . . . . . . : 192.168.0.103
> Subnet Mask . . . . . . . . : 255.255.255.0
> IP Address. . . . . . . . . : 192.168.0.101
> Subnet Mask . . . . . . . . : 255.255.255.0
> IP Address. . . . . . . . . : 192.168.0.100
> Subnet Mask . . . . . . . . : 255.255.255.0
> IP Address. . . . . . . . . : 192.168.0.105
> Subnet Mask . . . . . . . . : 255.255.255.0
> IP Address. . . . . . . . . : 192.168.0.107
> Subnet Mask . . . . . . . . : 255.255.255.0
> IP Address. . . . . . . . . : 192.168.0.8
> 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 {52ED9D48-488E-4265-AC55-3CE5BBFDBF23}:
> Description . . . . . . . . : Broadcom NetXtreme Gigabit
> Ethernet
> Physical Address. . . . . . : 00-14-22-73-F9-C9
> DHCP Enabled. . . . . . . . : no
> IP Address. . . . . . . . . : 207.x.x.253
> Subnet Mask . . . . . . . . : 255.255.255.248
> IP Address. . . . . . . . . : 207.x.x.251
> Subnet Mask . . . . . . . . : 255.255.255.248
> IP Address. . . . . . . . . : 207.x.x.250
> Subnet Mask . . . . . . . . : 255.255.255.248
> Default Gateway . . . . . . : 207.x.x.249
> 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
> 193.x.x.147 HOSTB1
>
> Cluster Environment detected
> 03-06, 06:52:43.296-->Invalid IP Address:207.x.x.253
> (Mask:255.255.255.248) (38)
> MSDTC Virtual Name:DTC1, IP:
> ++++++++++++++++++++++++++++++++++++++++++++++
> DTCping 1.9 Report for
> ++++++++++++++++++++++++++++++++++++++++++++++
> Firewall Port Settings:
> Port:5000-5200
> RPC server is ready
> 03-06, 06:52:51.078-->RPC server: received following information:
> Network Name: HOSTA1
> Source Port: 5069
> Partner LOG: HOSTB15232.log
> Partner CID: CA74E8B7-5274-40DF-97F0-CCF7B89895A9
> ++++++++++++Start Reverse Bind Test+++++++++++++
> Received Bind call from HOSTB1
> Network Name: HOSTA1
> Source Port: 5069
> Hosting Machine:
> 03-06, 06:52:51.296-->Trying to Reverse Bind to HOSTB1...
> Test Guid:CA74E8B7-5274-40DF-97F0-CCF7B89895A9
> Name Resolution:
> HOSTB1-->193.x.x.147-->HOSTB1
> Reverse Binding success: -->HOSTB1
> ++++++++++++Reverse Bind Test ENDED++++++++++
> 03-06, 06:52:52.296-->Called POKE from Partner:HOSTB1
> Network Name: HOSTA1
> Source Port: 5069
> Hosting Machine:
> ++++++++++++Validating Remote Computer Name++++++++++++
> 03-06, 06:52:55.140-->Start DTC connection test
> Name Resolution:
> HOSTB1-->193.x.x.147-->HOSTB1
> 03-06, 06:52:55.156-->Start RPC test (-->HOSTB1)
> RPC test is successful
> Partner's CID:CA74E8B7-5274-40DF-97F0-CCF7B89895A9
> ++++++++++++RPC test completed+++++++++++++++
> ++++++++++++Start DTC Binding Test +++++++++++++
> Trying Bind to HOSTB1
> 03-06, 06:52:55.296--> Initiating DTC Binding Test...
> Test Guid:66C8FDED-CEC3-4C56-A4F6-F6EA236DAD5F
> Received reverse bind call from HOSTB1
> Network Name: HOSTA1
> Source Port: 5069
> Hosting Machine:
> Binding success: -->HOSTB1
> ++++++++++++DTC Binding Test END+++++++++++++
>