December 26, 2001 at 3:56 am
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.
December 26, 2001 at 8:16 am
see other post. Pls do not cross post. We check all the forums for new messages.
Steve Jones
December 26, 2001 at 8:20 am
My guess is that its a permissions problem. You know you've got connectivity, so that rules just about everything else out except a problem with either the oledb driver or the DTC. Maybe try running the DTC in both domains with same account name and password?
Andy
December 26, 2001 at 2:34 pm
You'd need to specify one service using a domain acct from the other domain. Not sure if you can do this. You might need a trust between domains.
Steve Jones
December 26, 2001 at 4:26 pm
Wouldnt the trust be working already if you could run the transaction, just not inside the distributed wrapper?
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply