?
Solved

DTCTester error, can anyone help

Posted on 2007-11-30
6
Medium Priority
?
3,417 Views
Last Modified: 2013-12-01
Hi

I have 2 SQL 2005 Servers which are both Windows Server 2003 and both running MSDTC yet I am having issues getting the MSDTC to work.

When testing the MSDTC connection using dtctester I get the following error.

Executed: dtctester
DSN:  LON1DB01
User Name: sa
Password:
tablename= #dtc9869
Creating Temp Table for Testing: #dtc9869
Warning: No Columns in Result Set From Executing: 'create table #dtc9869 (ival int)'
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
Error:
SQLSTATE=37000,Native error=8509,msg='[Microsoft][ODBC SQL Server Driver][SQL Server]Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x8004d01f(error not found).'
Error:
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid cursor state
Typical Errors in DTC Output When
a.  Firewall Has Ports Closed
-OR-
b.  Bad WINS/DNS entries
-OR-
c.  Misconfigured network
-OR-
d.  Misconfigured SQL Server machine that has multiple netcards.
Aborting DTC Transaction
Releasing DTC Interface Pointers
Successfully Released pTransaction Pointer.

Has anyone had this problem before?
0
Comment
Question by:PilgrimSupport
  • 2
  • 2
5 Comments
 
LVL 29

Expert Comment

by:Dan McFadden
ID: 20388230
You may want to verifiy the configurations of the DTC on both servers.   Make sure that TIP is enabled.

Have you tried DTCPing to verifiy that the 2 DTC services can successfully communicate?
0
 

Author Comment

by:PilgrimSupport
ID: 20394724
Thanks for the suggestion, I have run DTCping on both servers but don't understand the output, can anyone enlighten me please?  Attached the output below.

LON3
---------------------------------
Platform:Windows 2003
      Windows 2003 environment is detected:
      Reading MSDTC settings from local registry:
Security settings for DTC under Windows 2003
      NetworkDtcAccess            :true
      NetworkDtcAccessAdmin       :false
      NetworkDtcAccessClients     :true
      NetworkDtcAccessTransactions:true
      NetworkDtcAccessTip         :true
      XaTransactions              :true
      DomainControllerState       :false
      AccountName                 :NT Authority\NetworkService
      TurnOffRpcSecurity          :false

IP Configure Information
      Host Name . . . . . . . . . : lon1db03
      DNS Servers . . . . . . . . : xxxxxxxxxxxx
                                       xxxxxxxxxxxx
      Node Type . . . . . . . . . :
      NetBIOS Scope ID. . . . . . :
      IP Routing Enabled. . . . . : no
      WINS Proxy Enabled. . . . . : no
      NetBIOS Resolution Uses DNS : no

Ethernet adapter {E889F0FB-22C2-4404-A1AF-0F1EDC1D754F}:

      Description . . . . . . . . : Broadcom BCM5708C NetXtreme II GigE (NDIS VBD Client)
      Physical Address. . . . . . : 00-1A-64-24-D5-48
      DHCP Enabled. . . . . . . . : no
      IP Address. . . . . . . . . : xxxxxxxxxxxxxxxxxx
      Subnet Mask . . . . . . . . : xxxxxxxxxxxxx
      Default Gateway . . . . . . : xxxxxxxxxxxxxxxxxx
      DHCP Server . . . . . . . . : xxxxxxxxxxxxxxx
      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 LON1DB03  
++++++++++++++++++++++++++++++++++++++++++++++
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
12-03, 10:45:46.486-->Start DTC connection test
Name Resolution:
      lon1db01-->xxxxxxxxxxxxx-->lon1db01.ch.local
12-03, 10:45:46.501-->Start RPC test (LON1DB03-->lon1db01)
RPC test is successful
      Partner's CID:5201081C-6047-4873-B3EF-9CBE16C3B2F9
++++++++++++RPC test completed+++++++++++++++
++++++++++++Start DTC Binding Test +++++++++++++
Trying Bind to lon1db01
12-03, 10:45:46.517-->LON1DB03 Initiating DTC Binding Test....
      Test Guid:D860FB82-58E0-4FB0-BDE3-F49F90C9D5DA
Received reverse bind call from lon1db01
      Network Name: lon1db03
      Source  Port: 2155
      Hosting Machine:LON1DB03
Binding success: LON1DB03-->lon1db01
++++++++++++DTC Binding Test END+++++++++++++
12-03, 10:46:10.204-->RPC server:LON1DB03 received following information:
      Network Name: lon1db03
      Source  Port: 2155
      Partner LOG: LON1DB014552.log
      Partner CID: 5201081C-6047-4873-B3EF-9CBE16C3B2F9
++++++++++++Start Reverse Bind Test+++++++++++++
Received Bind call from LON1DB01
      Network Name: lon1db03
      Source  Port: 2155
      Hosting Machine:LON1DB03
12-03, 10:46:10.298-->Trying to Reverse Bind to LON1DB01...
      Test Guid:5201081C-6047-4873-B3EF-9CBE16C3B2F9
Name Resolution:
      LON1DB01-->xxxxxxxxxxxxxxx-->lon1db01.ch.local
Reverse Binding success: LON1DB03-->LON1DB01
++++++++++++Reverse Bind Test ENDED++++++++++


lon1
--------------------------------
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       :false
      NetworkDtcAccessClients     :true
      NetworkDtcAccessTransactions:true
      NetworkDtcAccessTip         :true
      XaTransactions              :true
      AccountName                 :NT Authority\NetworkService
      NetworkDtcAccessOutbound    :false
      TurnOffRpcSecurity          :false
      FallbackToUnsecureRPCIfNecessary:false
      AllowOnlySecureRpcCalls     :false

IP Configure Information
      Host Name . . . . . . . . . : lon1db01
      DNS Servers . . . . . . . . : xxxxxxxxxxxxxx
                                       xxxxxxxxxxxxxx
      Node Type . . . . . . . . . :
      NetBIOS Scope ID. . . . . . :
      IP Routing Enabled. . . . . : no
      WINS Proxy Enabled. . . . . : no
      NetBIOS Resolution Uses DNS : no

Ethernet adapter {51963E9A-D28C-47E9-AB96-C510A14C8B27}:

      Description . . . . . . . . : HP NC7781 Gigabit Server Adapter
      Physical Address. . . . . . : 00-0D-9D-4E-06-EB
      DHCP Enabled. . . . . . . . : no
      IP Address. . . . . . . . . : xxxxxxxxxxxxxx
      Subnet Mask . . . . . . . . : xxxxxxxxx
      Default Gateway . . . . . . : xxxxxxxxxxxxxxx
      DHCP Server . . . . . . . . : xxxxxxxxxxxxxxx
      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 LON1DB01  
++++++++++++++++++++++++++++++++++++++++++++++
RPC server is ready
12-03, 10:45:46.532-->RPC server:LON1DB01 received following information:
      Network Name: lon1db01
      Source  Port: 3194
      Partner LOG: LON1DB032604.log
      Partner CID: D860FB82-58E0-4FB0-BDE3-F49F90C9D5DA
++++++++++++Start Reverse Bind Test+++++++++++++
Received Bind call from LON1DB03
      Network Name: lon1db01
      Source  Port: 3194
      Hosting Machine:LON1DB01
12-03, 10:45:46.625-->Trying to Reverse Bind to LON1DB03...
      Test Guid:D860FB82-58E0-4FB0-BDE3-F49F90C9D5DA
Name Resolution:
      LON1DB03-->xxxxxxxxxxxxxx-->lon1db03.ch.local
Reverse Binding success: LON1DB01-->LON1DB03
++++++++++++Reverse Bind Test ENDED++++++++++
12-03, 10:45:46.704-->Called POKE from Partner:LON1DB03
      Network Name: lon1db01
      Source  Port: 3194
      Hosting Machine:LON1DB01
++++++++++++Validating Remote Computer Name++++++++++++
12-03, 10:46:10.235-->Start DTC connection test
Name Resolution:
      lon1db03-->xxxxxxxxxxxx-->lon1db03.ch.local
12-03, 10:46:10.235-->Start RPC test (LON1DB01-->lon1db03)
RPC test is successful
      Partner's CID:D860FB82-58E0-4FB0-BDE3-F49F90C9D5DA
++++++++++++RPC test completed+++++++++++++++
++++++++++++Start DTC Binding Test +++++++++++++
Trying Bind to lon1db03
12-03, 10:46:10.250-->LON1DB01 Initiating DTC Binding Test....
      Test Guid:5201081C-6047-4873-B3EF-9CBE16C3B2F9
Received reverse bind call from lon1db03
      Network Name: lon1db01
      Source  Port: 3194
      Hosting Machine:LON1DB01
Binding success: LON1DB01-->lon1db03
++++++++++++DTC Binding Test END+++++++++++++


Thank you.
0
 
LVL 29

Expert Comment

by:Dan McFadden
ID: 20395148
This results indicate that MSDTC on both servers can communicate.

Also, from the DTCping output, I noticed that one server is running Win2K3 with no SP and the other is running Win2K3 SP1.  I believe there are updates to MSDTC in SP2 that effect its operation.  I know its a cop out, I would recommend that SP2 + hotfixes be deployed.

Also, were these 2 servers cloned or ghosted during install?  If so, you will want to uninistall msdtc and reinstall it.
(msdtc -uninstall, then msdtc -install)
0
 

Author Comment

by:PilgrimSupport
ID: 20396004
Many thanks for your input, but the call has now been resolved

Client did not have outbound transactions allowed in MSDTC, the simplest things eh?
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 22506215
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Considering today’s continual security threats, which affect Information technology networks and systems worldwide, it is very important to practice basic security awareness. A normal system user can secure himself or herself by following these simp…
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question