Solved

DTCTester error, can anyone help

Posted on 2007-11-30
6
3,149 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
6 Comments
 
LVL 26

Expert Comment

by:Dan McFadden
Comment Utility
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
Comment Utility
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 26

Expert Comment

by:Dan McFadden
Comment Utility
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
Comment Utility
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
Comment Utility
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
I previously wrote an article addressing the use of UBCD4WIN and SARDU. All are great, but I have always been an advocate of SARDU. Recently it was suggested that I go back and take a look at Easy2Boot in comparison.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

728 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now