I have 2 servers running windows 2008 64-bit datacenter edition. I have enabled DTC service http://msdn.microsoft.com/en-us/library/dd327979(CS.90).aspx
. But still DTC services are not talking to each other. I checked for the port 135, its opened.
SQL 2008 is installed on both servers. Linked server is working fine but DTC has issue. Error found in sql query is
"The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "server-01" was unable to begin a distributed transaction".
Event ID : 4879
Event Viewer message:
"OLE DB provider "SQLNCLI10" for linked server "server-01" returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Line 2"
Is there any more settings to be done to enable this or is this issue is due to 64bit??