DTC Error

I have a project with two SQL servers on two seperate
subnet, following distribute query will run on B server.
update [xxx.xxx.xxx.xxx].[abce].[dbo].[abcede] set
uploadstatus='InProgress'
If I include this statement in Transaction Like this way:
Begin Tran
update [xxx.xxx.xxx.xxx].[abce].[dbo].[abcede] set
uploadstatus='InProgress'
commit Tran
I got following error' 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].'
Link server is setup okay for sure, any suggestions from
microsoft?
For DTC , two sql server have to be the same subnet or
same domain?
Thanks
David Liu
MCSE/MCDBA
Moneris.com
Is one of the servers Windows Server 2003 by any chance - see below
http://support.microsoft.com/default...b;en-us;816701
Andy Ball
Greenfell Computing Ltd
"David Liu" <david.z.liu@.moneris.com> wrote in message
news:2ef101c4289c$c6c0a660$a101280a@.phx.gbl...
> I have a project with two SQL servers on two seperate
> subnet, following distribute query will run on B server.
> update [xxx.xxx.xxx.xxx].[abce].[dbo].[abcede] set
> uploadstatus='InProgress'
> If I include this statement in Transaction Like this way:
> Begin Tran
> update [xxx.xxx.xxx.xxx].[abce].[dbo].[abcede] set
> uploadstatus='InProgress'
> commit Tran
> I got following error' 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].'
> Link server is setup okay for sure, any suggestions from
> microsoft?
> For DTC , two sql server have to be the same subnet or
> same domain?
> Thanks
> David Liu
> MCSE/MCDBA
> Moneris.com
>
>
>
|||Both of them are Windows 2000 Advanced Server.
Does this case need to be same subnet and same domain?
DTC use RPC for communication for sure.
Really wired
Thanks for your information

>--Original Message--
>Is one of the servers Windows Server 2003 by any chance -
see below
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;816701[vbcol=seagreen]
>
>--
>Andy Ball
>Greenfell Computing Ltd
>"David Liu" <david.z.liu@.moneris.com> wrote in message
>news:2ef101c4289c$c6c0a660$a101280a@.phx.gbl...
way:[vbcol=seagreen]
cannot
>
>.
>