February 27, 2012 at 11:55 pm
hi,
1. select * from view name - it is working fine
I can able to access remote database data in sql server 2000 machine by using OPENROWSET,
If using second option - failed
2. begin tran
select * from view name - it is working fine
commit tran
Server: Msg 7391, Level 16, State 1, Line 1
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. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
please help, how to resolve it?
February 28, 2012 at 1:19 am
You need to investigate what is going on with DTC (Distributed Transaction Coordinator)
Is it running on both machines involved?
Can the two DTC instances communicate? - it is a long time since I have investigated a problem with this but I found we had a firewall between the two servers and the correct ports for DTC were not opened.
Historically DTC was installed with SQL server, but at some point it became a Windows component. Either way a review of errors from it in the Event log should point you in the right direction.
Mike
February 28, 2012 at 1:40 am
hi,
Thanks for reply...
I have checked as you suggested, MS DTC services was stoped at two server,
if I start these services to enable Network DTC access and INBOUND/OUTBOUND also enabled,
in this case our Active directoy will stoped after enbale those option.
thanks
ananda
February 28, 2012 at 1:46 am
Ananda
Just as a matter of interest, why are you wrapping a SELECT statement in an explicit transaction?
John
February 28, 2012 at 2:27 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply