dbTalk Databases Forums  

New transaction cannot enlist in the specified transaction coordinator

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss New transaction cannot enlist in the specified transaction coordinator in the microsoft.public.sqlserver.dts forum.



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

Default New transaction cannot enlist in the specified transaction coordinator - 11-08-2006 , 01:56 PM






Hi,
I have my ASP and MTS on one machine and SQL Server on my machine.
DTCPing works successfully between both the machines but I continue
getting the following error when the MTS object tries to connect to SQL
Server.

"Microsoft OLE DB Provider for SQL Server error '8004d00a'
New transaction cannot enlist in the specified transaction coordinator.
"

Please help if anyone has faced the same kind of problem before.

I have gone thro' most of the microsoft kbb articles.

Thanks,
Kavitha


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 - 2012, Jelsoft Enterprises Ltd.