DTCTester error, can anyone help
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
Error:
SQLSTATE=24000,Native error=0,msg=[Microsoft][OD
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?
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
Error:
SQLSTATE=24000,Native error=0,msg=[Microsoft][OD
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?
Who is Participating?
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?
Have you tried DTCPing to verifiy that the 2 DTC services can successfully communicate?
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
NetworkDtcAccessTransactio
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-0
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--
12-03, 10:45:46.501-->Start RPC test (LON1DB03-->lon1db01)
RPC test is successful
Partner's CID:5201081C-6047-4873-B3E
++++++++++++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-BD
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-9C
++++++++++++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-B3
Name Resolution:
LON1DB01-->xxxxxxxxxxxxxxx
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
NetworkDtcAccessTransactio
NetworkDtcAccessTip :true
XaTransactions :true
AccountName :NT Authority\NetworkService
NetworkDtcAccessOutbound :false
TurnOffRpcSecurity :false
FallbackToUnsecureRPCIfNec
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-C
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-F4
++++++++++++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-BD
Name Resolution:
LON1DB03-->xxxxxxxxxxxxxx-
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-->
12-03, 10:46:10.235-->Start RPC test (LON1DB01-->lon1db03)
RPC test is successful
Partner's CID:D860FB82-58E0-4FB0-BDE
++++++++++++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-B3
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.
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
NetworkDtcAccessTransactio
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-0
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--
12-03, 10:45:46.501-->Start RPC test (LON1DB03-->lon1db01)
RPC test is successful
Partner's CID:5201081C-6047-4873-B3E
++++++++++++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-BD
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-9C
++++++++++++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-B3
Name Resolution:
LON1DB01-->xxxxxxxxxxxxxxx
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
NetworkDtcAccessTransactio
NetworkDtcAccessTip :true
XaTransactions :true
AccountName :NT Authority\NetworkService
NetworkDtcAccessOutbound :false
TurnOffRpcSecurity :false
FallbackToUnsecureRPCIfNec
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-C
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-F4
++++++++++++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-BD
Name Resolution:
LON1DB03-->xxxxxxxxxxxxxx-
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-->
12-03, 10:46:10.235-->Start RPC test (LON1DB01-->lon1db03)
RPC test is successful
Partner's CID:D860FB82-58E0-4FB0-BDE
++++++++++++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-B3
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.
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)
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)
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?
Client did not have outbound transactions allowed in MSDTC, the simplest things eh?
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
Computer101
EE Admin