Backlash
asked on
MSDTC Problem using asp.net with sql server on separate machine
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
Did you try the registry edit from the link in my comment? That's the only way I know of to fix that error.
I have tried the registry fix , and it doesent seem to work either.
Any other ideas
Any other ideas
ASKER
http://support.microsoft.com/?id=827805
That worked for me, even though the error message and everything else were different.