DTC Error

Hi there,
We are having a issue with MSDTC saying that the DTC service is unavailable
when runing a distributed transaction between two WIN2003 servers running
SQL 2000 SP3. Have read all the articles but I am not having much sucess.
Have enabled network DTC access on both servers. The service account is
running under a domain admin account. It seems that one server is the common
donominator as all distributed transactions with this server fails. We read
an article that said to add the reg value:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\TurnOf fRpcSecurity = 1, this had
the effect of changing the error message to:
Server: Msg 7391, Level 16, State 1, Line 2
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].
Not sure where to look next, any assistance will be appreciated.
Thanks
Devron Blatchford.
Hi,
I had a similar problem with my Distributed transactions and the problem was
the name resolution within the two servers. I downloaded the MS DTCPing.exe
from microsoft and i found that there wasn't the appropriate name resolution.
Also, if your servers aren't in the same domain, you must trust these domains.
Download the MS DTCPing.exe from the following article
http://support.microsoft.com/default...b;en-us;306843
Andreas
"Devron Blatchford" wrote:

> Hi there,
> We are having a issue with MSDTC saying that the DTC service is unavailable
> when runing a distributed transaction between two WIN2003 servers running
> SQL 2000 SP3. Have read all the articles but I am not having much sucess.
> Have enabled network DTC access on both servers. The service account is
> running under a domain admin account. It seems that one server is the common
> donominator as all distributed transactions with this server fails. We read
> an article that said to add the reg value:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\TurnOf fRpcSecurity = 1, this had
> the effect of changing the error message to:
> Server: Msg 7391, Level 16, State 1, Line 2
> 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].
> Not sure where to look next, any assistance will be appreciated.
> Thanks
> Devron Blatchford.
>
>