MSDTC issue after recent upgrade from 2000 to 2005

[Offeral]

After upgrading to 2005 on a server we are having problems running
distributed transactions. When attempting to insert the output of a remote
procedure into a temp table we get the error:

Msg 8501, Level 16, State 3, Procedure <proc name>, Line 34
MSDTC on server <server name> is unavailable.

During troubleshooting, I used dtctester to get the following error:

DtcGetTransactionManager failed: 8004d01b
DtcGetTransactionManager Call Error: Indicates unable to connect to the
transact
ion manager, or the transaction manager is unavailable.

Also using dtcping I get:

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.

The DTC is started and logs in as an account that has domain admin
priveledges.
RPC is also started but logs as a Network Service.

If there is any other information necessary I can provide it, but I'm
pulling my hair out over here over this silly little thing (even though
rewriting is probably more efficient).

Thanks in advance,
Offeral

[Offeral]

Nevermind, the problem was that the DTC logon account should have been
NTAuthority\Network Service in the Security Configuration of MSDTC.

O

[John Bell]

Hi

Have you checked http://tinyurl.com/2tdbtf

You can enable dtc logging http://support.microsoft.com/kb/899115

As this is an upgrade have you changed the OS? There are several issues with
Windows 2003 that you may need to check.

John

Post by Offeral
Nevermind, the problem was that the DTC logon account should have been
NTAuthority\Network Service in the Security Configuration of MSDTC.
O