Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Network DTC/Transaction from 2000 to 2005 problems

Posted on 2007-03-23
14
Medium Priority
?
1,080 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
[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
  • 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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

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
 

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 to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

715 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