BEGIN DISTRIBUTED TRANSACTION
SELECT TOP 1 col1 FROM LinkedServer1.db1.dbo.tbl1
ROLLBACK TRAN

OLE DB provider "SQLNCLI10" for linked server "LinkedServer1" returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Line 3
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "LinkedServer1" was unable to begin a distributed transaction.

Gianluca Sartori (10/22/2010)

---

Can the two DTC connect to each other?
Have you checked that with DTCPing?

++++++++++++Start DTC Binding Test +++++++++++++
Trying Bind to RemoteSrvr1
10-22, 12:57:09.192-->LocalSrvr1 Initiating DTC Binding Test....
Test Guid:FA12FEB1-8D3D-4297-B8F2-3A71341D788A
Binding call to RemoteSrvr1 Failed
In GUID
Out GUID
Session Down

begin distributed transaction
select * from LinkedSrvrName.dbName.dbo.tblName
rollback tran

OLE DB provider "SQLNCLI10" for linked server "LinkedSrvrName" returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Line 4
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "LinkedSrvrName" was unable to begin a distributed transaction.