Solved

MSDTC Problem using asp.net with sql server on separate machine

Posted on 2004-03-26
5
5,392 Views
Last Modified: 2012-06-22
We have an asp.net solution that we are moving from Windows 2000 to Windows 2003.  We have one webserver (using the built-in IIS6) and a separate db server running SQL Server 2k.  

Some pages use the .net automatic transaction functionality, by adding Transaction=Required in the Page directive.  Unfortunately, those pages do not work anymore.  I researched this and tried a lot of solutions, including this (quote):

go to Administrative Tools group
click the Component Services shortcut
expand Component Services treeview item
expand the Computers treeview item
right-click the My Computer treeview item
choose Properties from the pop-up menu
click the MSDTC tab
click the Security Configuration button
play with the shiny checkboxes

That fixed my original error, which was this:
The partner transaction manager has disabled its support for remote/network
transactions.

Now I get this error:
The transaction has already been implicitly or explicitly committed or aborted

I cannot get this to work!  I have seen plenty of posts by other people with this problem, but no solution has worked for me.  Please help!
0
Comment
Question by:Backlash
  • 2
  • 2
5 Comments
 

Author Comment

by:Backlash
ID: 10691958
Of course, after working on this for like 6 or 7 hours, as soon as I post my question here in desparation I get it working.  

http://support.microsoft.com/?id=827805

That worked for me, even though the error message and everything else were different.
0
 

Accepted Solution

by:
DigitalXtreme earned 0 total points
ID: 10692903
PAQ'ed and points refunded.

DigitalXtreme
Community Support Moderator
0
 

Expert Comment

by:darronman
ID: 11566412
Help , i have tried your solution and im still getting the same error. By adjusting the DTC my error has now also changed to The transaction has already been implicitly or explicitly committed or aborted . I cannt get past this point no matter what i try.
0
 

Author Comment

by:Backlash
ID: 11568353
Did you try the registry edit from the link in my comment?  That's the only way I know of to fix that error.
0
 

Expert Comment

by:darronman
ID: 11581281
I have tried the registry fix , and it doesent seem to work either.
Any other ideas
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many of us need to configure DHCP server(s) in their environment. We can do that simply via DHCP console on server or using MMC snap-in on each computer with Administrative Tools installed in a network. But what if we have to configure many DHCP ser…
I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now