MS SQL Server - Error 7391 when distributed transaction started

Author

Error 7391 when distributed transaction started

FRF

2006-04-06, 8:23 pm

Node 1:
Windows 2003 Server Standar Edition SP1
SQL Server 2005 Standar Edition

Node 2:
Windows 2000 Server SP4
SQL Server 2000 Standar Edition SP3a

Node 1 have node 2 like "linked server", node 2 have node 1 like "linked
server" too.
Both nodes use Microsoft OLE DB Provider for SQL Server.

Node 1 begins a distributed transaction vs Node 2.

Transaction KO with
"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::Jo
inTransaction returned 0x8004d00a]."

MS DTS is configured in Node 1 like microsoft said in
http://suppport.microsoftl.com/defa...kb;en-us;329332

If I change Node1 with Windows 2000 Server Standard Edition and SQL Server
2000 SP3a, the distribution transaction run OK.

Thanks a lot.

John Bell

2006-04-07, 3:24 am

Hi

Windows 2003 has more secure defaults than Windows 2000 therefore it is
probably something that has not been configured that is causing the problem

Check out http://support.microsoft.com/kb/839279/
http://support.microsoft.com/kb/191168/
http://support.microsoft.com/kb/306843/
http://support.microsoft.com/kb/306843/
http://support.microsoft.com/kb/329332
http://support.microsoft.com/kb/306212

You can use DTCPing to check it can communicate with the server
http://download.microsoft.com/downl...5c1/dtcping.exe

John

"FRF" wrote:

> Node 1:
> Windows 2003 Server Standar Edition SP1
> SQL Server 2005 Standar Edition
>
> Node 2:
> Windows 2000 Server SP4
> SQL Server 2000 Standar Edition SP3a
>
> Node 1 have node 2 like "linked server", node 2 have node 1 like "linked
> server" too.
> Both nodes use Microsoft OLE DB Provider for SQL Server.
>
> Node 1 begins a distributed transaction vs Node 2.
>
> Transaction KO with
> "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::Jo
inTransaction returned 0x8004d00a]."
>
> MS DTS is configured in Node 1 like microsoft said in
> http://suppport.microsoftl.com/defa...kb;en-us;329332
>
> If I change Node1 with Windows 2000 Server Standard Edition and SQL Server
> 2000 SP3a, the distribution transaction run OK.
>
> Thanks a lot.
>

Sponsored Links