Unanswered: <[OLE/DB provider returned message: New transaction cannot enlist in the specified tr
I'm new to this grp. when i come across the problem with linked server while running stored procedure saying "<[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]>" I googled that message and got the solution from msdn.
All we have to do to get rid of that message is change security configuration of MSDTC of Win XPsp2 or Win2003 server and also we need to enable port 135 to allow dtc to work using RPC. Now it seems the problem is resolved. But still the problem is occuring once every a while.
I'm scraching my brain wht could be the reason. i've tried all the ways but still the problem exists.
Hope i'm clear in explaining my problem. Am i?
Please help me