This question has been posted in so many forums yet there are no solid answers. I have 2 sql servers, for sake of this question call them A and B.
On server A, I have created a linked server connection to sever B. If I manage this linked server connection in Enterprise manager, I am able to see the tables in the database that I specified in the connection, which tells me that the linked server has been created correctly.
When I try and execute a query from server A, selecting data on server B I get the error.
Server: Msg 8501, Level 16, State 1, Line 2
MSDTC on server 'My Server Name' is unavailable.
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.
Server A is a standard installation of SQL, where server B is a clustered database running in an active / passive manner. As the two servers are running on seperate domains I have setup a two way trust. Both are running the Win2000 server sp4, with MDAC 2.8.
I have checked and MSDTC is running on both servers, and it is running on the cluster itself.
Can anyone think of a reason why it is still not working?