Since upgrading our sql sql servers from 2000 to 2005 on win2k3 servers, we've been having some distributed transaction problems. They seem to be intermittent messages about not being able to enlist transactions. I have checked around and most articles say that it has to do with security in the msdtc options under component services and all that seems to be good. I have been playing with the dtcping utility and am getting the follwing error. I have checked and the rpc service is started and the dtc service is started and so on.
DTCping log file: C:\Documents and Settings\joe\Desktop\Tempx\VOICESERVER11924.lRPC server is ready
Please Start Partner DTCping before pinging
++++++++++++Validating Remote Computer Name++++++++++++
Please refer to following log file for details:
C:\Documents and Settings\joe\Desktop\Tempx\VOICESERVER11924.log
Invoking RPC method on sqlserver2
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
Thanks, Joe
DTCping log file: C:\Documents and Settings\joe\Desktop\Tempx\VOICESERVER11924.lRPC server is ready
Please Start Partner DTCping before pinging
++++++++++++Validating Remote Computer Name++++++++++++
Please refer to following log file for details:
C:\Documents and Settings\joe\Desktop\Tempx\VOICESERVER11924.log
Invoking RPC method on sqlserver2
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
Thanks, Joe