In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.
Course Of The Month
4 days, 13 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
DTCTester error, can anyone help
Posted on 2007-11-30
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
6 Comments
Active today
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.
Active today
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?
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
- Query Syntax
- SQL
- Databases
- MySQL Server
- MongoDB
- NoSQL Databases, Percona
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…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have.
In this…
Suggested Courses
Course of the Month4 days, 13 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
690 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.