I guess you all know that famous error when trying to run DT using linked server ,
Server: Msg 7391, Level 16, State 1, Line 3
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].
I followed all instruction listed mentioned at MS support and nothing change still have the same error
my enviroment is run distrubited transaction using linked server from sql server 2000 Ent Sp4 on win 2003 SP2 to SQL Server 2008 Sp1 x64 For IA on win server 2008(cluster enviroment active\active) IA .
appricaite you suuport, thanks in advance
View Complete Post