Solved

Network DTC/Transaction from 2000 to 2005 problems

Posted on 2007-03-23
14
1,055 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

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

Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

808 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