DTC Problem.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Gustavo (Gustavo_at_discussions.microsoft.com)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 11:15:09 -0700

Hi there.

I'm having problems with MSDTC.

simple test :

begin distributed tran
select * from SQLINDUSTRIAL.master.dbo.sysdatabases
commit

where SQLINDUSTRIAL is a linked server.

the transaction begin to run ( I see it in green the DTC snap in) in server
A, but it never appears on server B ( the linked servers).

Both machines are win2000 (so, there's no win 2k3 security issues here).

I've tested with DTCPing both ways and it seems ok.

log A
******************************************************************************
Platform:Windows 2000
IP Configure Information
Host Name . . . . . . . . . : efactory1
DNS Servers . . . . . . . . : 172.17.29.16
172.17.31.153
172.17.31.57
127.0.0.1
Node Type . . . . . . . . . :
NetBIOS Scope ID. . . . . . :
IP Routing Enabled. . . . . : no
WINS Proxy Enabled. . . . . : no
NetBIOS Resolution Uses DNS : no

Ethernet adapter {72C15B93-2D27-4E91-8CC0-9B1A67399FD7}:

Description . . . . . . . . : Compaq Ethernet/FastEthernet or Gigabit NIC
Physical Address. . . . . . : 00-50-8B-AD-FE-D8
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . : 10.210.20.34
Subnet Mask . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . : 10.210.20.254
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 {23AEE79C-9F33-4F46-8008-1A78B1D047DF}:

Description . . . . . . . . : Compaq Ethernet/FastEthernet or Gigabit NIC
Physical Address. . . . . . : 00-50-8B-C7-5D-FA
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . : 169.254.0.1
Subnet Mask . . . . . . . . : 255.255.0.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
172.17.29.16 gesauto1

++++++++++++++++++++++++++++++++++++++++++++++
DTCping 1.8 Report for EFACTORY1
++++++++++++++++++++++++++++++++++++++++++++++
RPC server is ready
10-13, 09:00:35.984-->RPC server:EFACTORY1 received following information:
Network Name: efactory1.efaceria
Source Port: 1619
Partner LOG: INDUSTRIAL14780.log
Partner CID: F6BEEB7F-D9E0-4A27-A8FB-3E82DC53F36D
++++++++++++Start Reverse Bind Test+++++++++++++
Received Bind call from INDUSTRIAL1
Network Name: efactory1.efaceria
Source Port: 1619
Hosting Machine:EFACTORY1
10-13, 09:00:37.156-->Trying to Reverse Bind to INDUSTRIAL1...
Test Guid:F6BEEB7F-D9E0-4A27-A8FB-3E82DC53F36D
Name Resolution:
INDUSTRIAL1-->10.210.20.32-->INDUSTRIAL1
Reverse Binding success: EFACTORY1-->INDUSTRIAL1
++++++++++++Reverse Bind Test ENDED++++++++++
10-13, 09:00:58.796-->Called POKE from Partner:INDUSTRIAL1
Network Name: efactory1.efaceria
Source Port: 1619
Hosting Machine:EFACTORY1
++++++++++++Validating Remote Computer Name++++++++++++
10-13, 09:01:07.421-->Start DTC connection test
Name Resolution:
sqlindustrial-->10.210.20.21-->SQLINDUSTRIAL
10-13, 09:01:12.312-->Start RPC test (EFACTORY1-->sqlindustrial)
RPC test is successful
Partner's CID:F6BEEB7F-D9E0-4A27-A8FB-3E82DC53F36D
++++++++++++RPC test completed+++++++++++++++
++++++++++++Start DTC Binding Test +++++++++++++
Trying Bind to sqlindustrial
10-13, 09:01:12.796-->EFACTORY1 Initiating DTC Binding Test....
Test Guid:6667C91B-9A0D-4F94-A09B-5FBAD21CA969
Received reverse bind call from sqlindustrial
Network Name: efactory1.efaceria
Source Port: 1619
Hosting Machine:EFACTORY1
Binding success: EFACTORY1-->sqlindustrial
++++++++++++DTC Binding Test END+++++++++++++

******************************************************************************
******************************************************************************
******************************************************************************
******************************************************************************
******************************************************************************

logB

Platform:Windows 2000
IP Configure Information
Host Name . . . . . . . . . : industrial1
DNS Servers . . . . . . . . : 172.17.31.153
172.17.31.209
10.210.20.32
172.17.31.57
127.0.0.1
Node Type . . . . . . . . . :
NetBIOS Scope ID. . . . . . :
IP Routing Enabled. . . . . : no
WINS Proxy Enabled. . . . . : no
NetBIOS Resolution Uses DNS : no

Ethernet adapter {0675FEF9-952A-4F39-86D8-E6639D003E26}:

Description . . . . . . . . : Compaq Ethernet/FastEthernet or Gigabit NIC
Physical Address. . . . . . : 00-02-A5-47-B5-22
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . : 10.210.20.21
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 10.210.20.32
Subnet Mask . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . : 10.210.20.254
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 {451B419A-2F8B-4405-9BAC-00DD25B7663A}:

Description . . . . . . . . : Compaq Ethernet/FastEthernet or Gigabit NIC
Physical Address. . . . . . : 00-50-8B-AD-C6-96
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . : 10.210.17.35
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 10.210.17.36
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 10.210.17.32
Subnet Mask . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . : 10.210.17.254
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 {2EFE6EBF-CBF8-47B4-97D5-400C6FE507FB}:

Description . . . . . . . . : Compaq Ethernet/FastEthernet or Gigabit NIC
Physical Address. . . . . . : 00-50-8B-C8-1E-52
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . : 169.254.0.1
Subnet Mask . . . . . . . . : 255.255.0.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
10.210.20.21 SQLINDUSTRIAL
10.210.20.32 INDUSTRIAL1
10.210.20.33 INDUSTRIAL2
10.210.20.34 EFACTORY1
10.210.20.34 EFACTORY1\SQLACERIA
10.210.20.35 EFACTORY2
10.210.20.28 SQLDBSGL

Cluster Environment detected
10-13, 09:07:14.953-->Invalid IP Address:10.210.17.35 (Mask:255.255.255.0)
(33)
MSDTC Virtual Name:CLSINDUSTRIAL, IP:
++++++++++++++++++++++++++++++++++++++++++++++
DTCping 1.8 Report for INDUSTRIAL1
++++++++++++++++++++++++++++++++++++++++++++++
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
10-13, 09:07:40.671-->Start DTC connection test
Name Resolution:
efactory1-->10.210.20.34-->EFACTORY1
10-13, 09:07:40.859-->Start RPC test (INDUSTRIAL1-->efactory1)
RPC test is successful
Partner's CID:6667C91B-9A0D-4F94-A09B-5FBAD21CA969
++++++++++++RPC test completed+++++++++++++++
++++++++++++Start DTC Binding Test +++++++++++++
Trying Bind to efactory1
10-13, 09:07:41.750-->INDUSTRIAL1 Initiating DTC Binding Test....
Test Guid:F6BEEB7F-D9E0-4A27-A8FB-3E82DC53F36D
Received reverse bind call from efactory1
Network Name: industrial1.INDUSTRIALDOM
Source Port: 1585
Hosting Machine:INDUSTRIAL1
Binding success: INDUSTRIAL1-->efactory1
++++++++++++DTC Binding Test END+++++++++++++
10-13, 09:08:17.187-->RPC server:INDUSTRIAL1 received following information:
Network Name: industrial1.INDUSTRIALDOM
Source Port: 1585
Partner LOG: EFACTORY14000.log
Partner CID: 6667C91B-9A0D-4F94-A09B-5FBAD21CA969
++++++++++++Start Reverse Bind Test+++++++++++++
Received Bind call from EFACTORY1
Network Name: industrial1.INDUSTRIALDOM
Source Port: 1585
Hosting Machine:INDUSTRIAL1
10-13, 09:08:18.343-->Trying to Reverse Bind to EFACTORY1...
Test Guid:6667C91B-9A0D-4F94-A09B-5FBAD21CA969
Name Resolution:
EFACTORY1-->10.210.20.34-->EFACTORY1
Reverse Binding success: INDUSTRIAL1-->EFACTORY1
++++++++++++Reverse Bind Test ENDED++++++++++

******************************************************************************

I keep doing the remote select and the distributed transaction appears in
server A DTC snap-in, but it never shows up in the server B.

I don't know if it never reaches there, there's some kind of permission
issue , or what is going on ?

I have no firewall / proxy issues here either. Both machines are running in
a lan.

Any ideas how to proceed from here?

Thanx.

Relevant Pages

  • Re: Fully parallel Scheme-based language w/ evaluator
    ... Windows Server 2003 and networks in simple - and irreverent - terms. ... If networking really is a big deal, ... Concepts and Terminology in Part I, and The Design and Deployment of Network ...
    (comp.lang.misc)
  • Re: Outgoing POP3 email missing/lost/not received
    ... Funny thing is that I have had this ISP for 8 years and it has always been ... It looks like when you last ran CEICW, you set the ISP's mail server to: ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)
  • Re: Logon Server Unavailable
    ... There are currently no logon servers available to service ... You use a office laptop to connect the office VPN, when you map a network ... you may receive this message: "This account is the ... The server is not configured for transactions"> "A domain controller for your domain could not be contacted" ...
    (microsoft.public.windows.server.dns)
  • Re: Logon Server Unavailable
    ... There are currently no logon servers available to service ... You use a office laptop to connect the office VPN, when you map a network ... you may receive this message: "This account is the ... The server is not configured for transactions"> "A domain controller for your domain could not be contacted" ...
    (microsoft.public.windows.server.networking)
  • Re: Logon Server Unavailable
    ... There are currently no logon servers available to service ... You use a office laptop to connect the office VPN, when you map a network ... you may receive this message: "This account is the ... The server is not configured for transactions"> "A domain controller for your domain could not be contacted" ...
    (microsoft.public.windows.server.general)