Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DTC in VMware

Author  Topic 

dejjan
Yak Posting Veteran

99 Posts

Posted - 2006-01-12 : 09:09:19
Hello,
I could not use DTC in VMware. If I started Begin Distributed Transaction between to virtual machine where SQL Servers is running, I got this message:

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

I tried with msdtc -uninstall/install but it didn't help.
I seems that everything about DTC is correct (service,.. no error) but I could not perform Distributed Transaction.

VMware was installed by the same image. Maybe it could help as additional information.

So, any help ?

Thanks in advanced.

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-01-12 : 10:25:29
You may find these links helpful:

http://support.microsoft.com/kb/306212
http://support.microsoft.com/kb/816701
http://support.microsoft.com/kb/839279

CODO ERGO SUM
Go to Top of Page

dejjan
Yak Posting Veteran

99 Posts

Posted - 2006-11-06 : 12:55:52
Did anybody try this - to have two SQL Servers on different machines, in the same domain, both in VMWare, and to use distributed transaction

I cannot make it to work.
Go to Top of Page
   

- Advertisement -