Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Distributed Transaction Error on Connection open

Status
Not open for further replies.

shweta

Technical User
Mar 20, 2001
27
0
0
US
Hi,

Our webserver and database reside on different servers in the same LAN. For the past couple of days on pages that have the directive @Transaction=REQUIRED we have been getting the error

Microsoft OLE DB Provider for ODBC Drivers error '8004d00a'

[Microsoft][ODBC SQL Server Driver]Distributed transaction error


This error happens right when connection to the DSN is opened.

The ping between the two servers is working fine. When I look inside MTS, I can see the active transactions go up by 1 on the webserver but not on the database server.

Any ideas/suggestions?

Thanks,
Shweta
 
I'm having the same problem - about once every two months or so. I'm listening to see if someone else has an answer!
 
Hi,
Even I am having the same problem as above, if any have any ideas, plese reply.

Thanks in advance.
 
Solution:

-Go to Administrative Tools -> Component Services
-Right click on "My Computer"
-Select MSDTC tab.
-Click on the "Security Configuration" Button.
-check the "Network DTC Access checkbox
-finally, check "No Authentication Required" option button
or "Incoming Caller Authentication required" option button.


hope this will fix your issue.

-Srikanth Gobburu
 
Solution:

-Go to Administrative Tools -> Component Services
-Right click on "My Computer" -> Properties
-Select MSDTC tab.
-Click on the "Security Configuration" Button.
-check the "Network DTC Access checkbox
-finally, check "No Authentication Required" option button
or "Incoming Caller Authentication required" option button.


hope this will fix your issue.

-Srikanth Gobburu
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top