No firewall....
"Hilary Cotter" wrote:
> Is there a firewall between these two boxes? This could explain your
> problem.
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> Looking for a SQL Server replication book?
>
http://www.nwsu.com/0974973602.html >
> Looking for a FAQ on Indexing Services/SQL FTS
>
http://www.indexserverfaq.com >
>
>
> "Jonas Larsen" <JonasLarsen@discussions.microsoft.com> wrote in message
> news:583DB32B-A513-44DE-8DEF-50ACF5EF9C52@microsoft.com...
> > Guys
> >
> > I have an updateable transactional Replication. It works fine from
> > Publisher
> > to Subscriber but when I try to update a table on the Subscriber I get the
> > following error:
> >
> > Server: Msg 8501, Level 16, State 1, Line 5
> > MSDTC on server 'SERVERNAME\INSTANCE' is unavailable.
> > Server: Msg 7391, Level 16, State 1, Line 5
> > The operation could not be performed because the OLE DB provider
> > 'SQLOLEDB'
> > was unable to begin a distributed transaction.
> > OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
> > ITransactionJoin::JoinTransaction returned 0x8004d01c].
> >
> >
> > My Publisher is a Win2000 with SQL2000+SP4 and my subscriber is a Win2003
> > with SQL2000+SP4. The Publisher database is on an instance ( Used to be an
> > old cluster node however SQL was reinstalled but due to all the Production
> > systems the instance remained).
> >
> > Thanks.
> >
> > Regards
> > Jonas
>
>