Solved

Network DTC/Transaction from 2000 to 2005 problems

Posted on 2007-03-23
14
1,042 Views
Last Modified: 2009-07-29
Hello,

I am attempting to run a transaction via linked server from a 2000 instance to 2005 and receiving the error:

The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].

When I run the same query over a linked server from a 2005 instance to the same 2005 instance mentioned above, it works fine.

Now, what's even more odd is that from the same 2000 instance mentioned above, I can hit other 2005 instances without error. This leads me to believe I have a network issues of sorts.

Summary:
- 2000 to 2005 transactions do not work to this specific 2005 instance
- 2000 to 2000 and all other 2005's work fine
- 2005 to 2005 transaction works fine
- Network DTC is enabled on both sides (inbound and outbound) with no authentication required

This specific 2005 instance is in it's own subnet meaning that there are of course some network limitations. I recently had port 1433 (SQL) opened in attempts to resolve this, but that has not helped. What other ports if any would be involved for DTC? I've heard 3372 and 135 (RPC).

Also, I have another server in that subnet that I just attempted the same thing on and I had the same results. I can hit the box fine from 2005 but not from 2000.

The fact that I can hit all other 2005 instances from 2000 without error and that I can hit this 2005 instance from 2005 and not 2000 has me baffled. Network? DTC? SQL2000 configuration?

Any help is greatly appreciated.

Thank you
0
Comment
Question by:MrBean
  • 9
  • 2
14 Comments
 
LVL 9

Expert Comment

by:nito8300
ID: 18780753
0
 

Author Comment

by:MrBean
ID: 18781138
That has already been completed.
0
 
LVL 16

Expert Comment

by:rboyd56
ID: 18781557
Download DTCPing form this location:

http://www.microsoft.com/downloads/details.aspx?FamilyID=5e325025-4dcd-4658-a549-1d549ac17644&displaylang=en

It can be used to trouble shoot DTC problems
0
 

Author Comment

by:MrBean
ID: 18781580
I think I have resolved it by allowing remote proc trans from the 2000 machine.
0
 

Author Comment

by:MrBean
ID: 18781696
I lied, it's not working.
0
 

Author Comment

by:MrBean
ID: 18781805
I used that DTCPing and received the following:

++++++++++++Validating Remote Computer Name++++++++++++
Please refer to following log file for details:
      C:\temp\DEVSQL3752.log
Invoking RPC method on SDVDB1
Problem:fail to invoke remote RPC method
Error(0x6D9) at dtcping.cpp @303
-->RPC pinging exception
-->1753(There are no more endpoints available from the endpoint mapper.)
RPC test failed

What is this telling me? I was told by the Network Admin that RPC is open between the two. As stated, I can Link Server Transaction query this server from any other 2005 machine without issue, it's only from 2000 that I can not perform this transaction. Yet any 2000 instance to any other 2000 or 2005 work just fine.
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

Author Comment

by:MrBean
ID: 18781814
Hmmm, what is this all about when starting DTCPing?

"Please Start Partner DTCping before pinging"
0
 

Author Comment

by:MrBean
ID: 18781824
Answered my own question. Installed and started it on the destination server then reran it from the source.

Now it looks better:

++++++++++++Validating Remote Computer Name++++++++++++
Please refer to following log file for details:
      C:\temp\DEVSQL6000.log
Invoking RPC method on SDVDB1
RPC test is successful
++++++++++++RPC test completed+++++++++++++++
++++++++++++Start DTC Binding Test +++++++++++++
Trying Bind to SDVDB1
0
 

Author Comment

by:MrBean
ID: 18781851
Bind was successful as well.

I just ran it going the other way (2005 in its own network back to the 2000 in the main domain) and got the following:

++++++++++++Validating Remote Computer Name++++++++++++
Please refer to following log file for details:
      C:\Temp\SDVDB15716.log
Invoking RPC method on DEVSQL
Problem:fail to invoke remote RPC method
Error(0x6D9) at dtcping.cpp @303
-->RPC pinging exception
-->1753(There are no more endpoints available from the endpoint mapper.)
RPC test failed

But that is not the way the transaction is going ... still though, what is this telling me? Hopefully this help as I'm running out of ideas.
0
 

Author Comment

by:MrBean
ID: 18782167
We temporarily allowed access between the networks and it worked perfectly, so this is definitely a port issue.

We have RCP (135) and SQL (1433) opened. Anything else I can check?
0
 
LVL 16

Expert Comment

by:rboyd56
ID: 18782289
Not that I know of.
0
 

Accepted Solution

by:
MrBean earned 0 total points
ID: 18795360
Was able to successfully resolve issue with this article: http://support.microsoft.com/default.aspx?scid=kb;en-us;250367
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

708 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

18 Experts available now in Live!

Get 1:1 Help Now