dbTalk Databases Forums  

Distributed transaction....

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Distributed transaction.... in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
borleano
 
Posts: n/a

Default Distributed transaction.... - 07-19-2004 , 07:04 PM






I have the following error:
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. ]

I have DTC services running in both servers, SET XACT_ABORT clause, ip
address in hosts file, there´s not a firewall between servers,
The only difference is sql server version, server A have Personal
edition, server B have Standard edition Sql 2000...

what im doing wrong???

sorry for my english, but its not my native language...

Reply With Quote
  #2  
Old   
Simon Hayes
 
Posts: n/a

Default Re: Distributed transaction.... - 07-21-2004 , 01:31 PM







"borleano" <borleano (AT) yahoo (DOT) com.mx> wrote

Quote:
I have the following error:
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. ]

I have DTC services running in both servers, SET XACT_ABORT clause, ip
address in hosts file, there´s not a firewall between servers,
The only difference is sql server version, server A have Personal
edition, server B have Standard edition Sql 2000...

what im doing wrong???

sorry for my english, but its not my native language...
These articles might help:

http://support.microsoft.com/default.aspx?kbid=306212
http://support.microsoft.com/?kbid=839279

Simon




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.