SQL Server Performance Forum – Threads Archive
MSDTC Again and again…
Hi there. I’m having problems with MSDTC again. simple test : begin distributed transelect * 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.21SQLINDUSTRIAL
10.210.20.32INDUSTRIAL1
10.210.20.33INDUSTRIAL2
10.210.20.34EFACTORY1
10.210.20.34EFACTORY1SQLACERIA
10.210.20.35EFACTORY2
10.210.20.28SQLDBSGL 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.
Any informational or warning messages on Event viewer on both the machines? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Make sure all hostnames can be resolved between the servers. Even if you connect to the virtual sql clustername the MSDTC sometimes will resolve the IP of the physical node name instead of the virtual name.
Check the linked server properties, server options, ensure Data Access, RPC and RPC out are checked (enabled). Make sure it’s set up as an SQL Server too. Also, log in to the desktop of server A using the account that the SQL Server service runs as and check that it can log in (in query analyzer) to the other server. If it can, and can run SELECT * FROM master..sysdatabases, permissions are ok. Troubleshooting these distributed transaction issues can be very time-consuming & frustrating (as you’re probably already aware).
Tom Pullen
DBA, Oxfam GB
I don’t see anything strange in Event viewer. In both machines all seems ok. All names are resolved fine.
also yo can see that from the DTCPing logs.
it didn’t complain about anything. The linked server properties are ok. ( the three of them checked )
but the problem is not with the linked server, because if I do the select whithout the transaction stuff all is all right. I supponse the problem is when the DTC in machine A (the one where the select * from xxx is run) wants to connect to the other DTC. but I don’t know what else to check.
So I’m stuck here completely out of ideas…
Have you checked Network access for DTC. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
I believe that option is only for win2k3. (I had that problen once with 2003). But now, both servers are win 2000.
]]>