The linked machine is called 'DH-32011-W', and we can successfully run the following:
select * from [DH-32011-W].DataBase.dbo.Table
However, if we try and run a distributed transaction, like this (please note, this is only a demonstrative example, and is not the sort of query we actually want to do):
begin distributed transaction
select * from [DH-32011-W].DataBase.dbo.Table
commit transaction
then we get the following error message:
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
the 2 servers are in different domains.
praveena