TransactionScope implicitly or explicitly committed or aborted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am attempting to use the TransactionScope class to manage my transactions.
I am running into an issue. My web server [WEB1] is in an NT work group. My
SQL Server [SQL1] is in a domain. When my code attempts to execute the
Complete method of the TransactionScope object, I get the following error:

"The transaction has already been implicitly or explicitly committed or
aborted"

I have tried altering the registry entry to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\TurnOffRpcSecurity = 1 on both
SQL1 and WEB1. I restarted both machines to make sure that changes took
effect.

When I run the code from a web server that is on the same domain as SQL1,
the code executes successfully. It is NOT and option to add WEB1 to a
domain.

Any suggestions?
 
As I stated in my post, that has been tried. It has come to my attention
that when working with SQL 2000, the transactionscope object automatically
promotes the transaction to a distributed transaction EVERY time. Is this
behavior by design? I thought it was only supposed to promote if it had to
be distributed.

SP said:
try turning off TurnOffRpcSecurity as per this article

http://support.microsoft.com/kb/Q827805

-sp

Rick_Kierner said:
I am attempting to use the TransactionScope class to manage my transactions.
I am running into an issue. My web server [WEB1] is in an NT work group. My
SQL Server [SQL1] is in a domain. When my code attempts to execute the
Complete method of the TransactionScope object, I get the following error:

"The transaction has already been implicitly or explicitly committed or
aborted"

I have tried altering the registry entry to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\TurnOffRpcSecurity = 1 on both
SQL1 and WEB1. I restarted both machines to make sure that changes took
effect.

When I run the code from a web server that is on the same domain as SQL1,
the code executes successfully. It is NOT and option to add WEB1 to a
domain.

Any suggestions?
 
oops, sorry about that,

we have run into the same problem, and I can't believe that there's no
solution for this. Have you tried the DTCtester.exe from ms what did that
report?

SP

Rick_Kierner said:
As I stated in my post, that has been tried. It has come to my attention
that when working with SQL 2000, the transactionscope object automatically
promotes the transaction to a distributed transaction EVERY time. Is this
behavior by design? I thought it was only supposed to promote if it had to
be distributed.

SP said:
try turning off TurnOffRpcSecurity as per this article

http://support.microsoft.com/kb/Q827805

-sp

Rick_Kierner said:
I am attempting to use the TransactionScope class to manage my transactions.
I am running into an issue. My web server [WEB1] is in an NT work group. My
SQL Server [SQL1] is in a domain. When my code attempts to execute the
Complete method of the TransactionScope object, I get the following error:

"The transaction has already been implicitly or explicitly committed or
aborted"

I have tried altering the registry entry to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\TurnOffRpcSecurity = 1 on both
SQL1 and WEB1. I restarted both machines to make sure that changes took
effect.

When I run the code from a web server that is on the same domain as SQL1,
the code executes successfully. It is NOT and option to add WEB1 to a
domain.

Any suggestions?
 
DTC actually won't work. I'm ok with that. The network admins have stated
that they will not open the ports necessary and won't add the DB servers to
the same domain as the web server. I figure that's a battle not worth
fighting.

My concern is that I don't really want to use DTC. It adds another layer of
complexity and performance inhibition. I would like for the TransactionScope
object to work as I had understood it to work (automatic promotion to DTC
only when necessary). Does anyone know if there are any plans for this to
take place?

--
Rick_Kierner


SP said:
oops, sorry about that,

we have run into the same problem, and I can't believe that there's no
solution for this. Have you tried the DTCtester.exe from ms what did that
report?

SP

Rick_Kierner said:
As I stated in my post, that has been tried. It has come to my attention
that when working with SQL 2000, the transactionscope object automatically
promotes the transaction to a distributed transaction EVERY time. Is this
behavior by design? I thought it was only supposed to promote if it had to
be distributed.

SP said:
try turning off TurnOffRpcSecurity as per this article

http://support.microsoft.com/kb/Q827805

-sp

:

I am attempting to use the TransactionScope class to manage my transactions.
I am running into an issue. My web server [WEB1] is in an NT work group. My
SQL Server [SQL1] is in a domain. When my code attempts to execute the
Complete method of the TransactionScope object, I get the following error:

"The transaction has already been implicitly or explicitly committed or
aborted"

I have tried altering the registry entry to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\TurnOffRpcSecurity = 1 on both
SQL1 and WEB1. I restarted both machines to make sure that changes took
effect.

When I run the code from a web server that is on the same domain as SQL1,
the code executes successfully. It is NOT and option to add WEB1 to a
domain.

Any suggestions?
 
Back
Top