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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy