I have 2 SQL 2000 servers connected with network.
There is no firewall between them.
MSDTC is running on both servers.
One of the 2 servers is called locale the other is called base.
The base one is a linked server in the locale SQL server.
The base server is on Win server 2003 while the locale server is on Win XP SP1.
The distributed transaction is located in the locale server and trying to insert into the base server.
Every time I encounter this error:
Server: Msg 7391, Level 16, State 1, Procedure proc_UpdateDataFromLocalToServer, Line 8
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. ]
-
What are the possible causes of this error?
Thank you.
Bishoy
Can you try to define a linked server between these two servers and execute the script containing the distributed transaction?|||Take help from this KBA http://support.microsoft.com/kb/839279 & http://support.microsoft.com/kb/329332 for a solution.
No comments:
Post a Comment