469,272 Members | 1,435 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,272 developers. It's quick & easy.

Unable to begin a distributed transaction

Having a SQL Server 2K (SP3a) with a link to another SQL Server 2K (no
service packs), distributed transactions works as expected most of the
time.
But occasionally the MSDTC(s) seems to fall in a state of failure,
causing the following error when involving distributed transactions:

"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]."

The only way out of this state is to stop and start both of the SQL
Servers (stop/start of the DTC's doesn't help).

Is this a common problem?
Guess I will be recommended to install SP on the server without
service packs, but will this positively solve the problem described
above?

Could general network failures cause the error state described above,
and if so - is there a way to make the MSDTC's survive or recover from
the error situation automatically?

--
Morten Haugen
Jul 20 '05 #1
0 5083

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.