I have been trying to run a distributed transaction query from SQL server 2008 SP1 installed. Other server is also with same configuration(SQL 2008 SP1).
I have configured all the MSDTC options in both the server. Firewall is disabled in both the server.
I am able to create linked server and also ran the normal query.It worked fine. But if I am running same query with BEGIN DISTRIBUTED TRAN, I am getting error as:
"The Microsoft Distribution Transaction coordinator (MS DTC) has cancelled the Ditribution transaction"
Thanks in advance