I have two dell servers with win2003 server and SQL 2k.
I want to do a distributed transaction.
I created a publication and enabled it for immediate update with queued failover.
My transactions distribute fine to the subscriber, but if I use immediate update MSDTC for the subscriber update method I get "MSDTC on server 'servername' is unavailable."
MSDTC shows that it is started and running in the SQL Service managers for both machines.
Do I actually need to create a win2003 cluster to get MSDTC to cooperate for me?