MSDTC cancelled distrubution transaction

See more:

SQL

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