Re: distributed transaction problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mark Jen [MSFT] (markjen_at_online.microsoft.com)
Date: 03/09/04 

Date: Mon, 8 Mar 2004 19:45:59 -0800

Hi Steve,

Could you give us some more details about your middle tier code? Is it a
ServicedComponent? Is it marked with a TransactionAttribute? Are you
connecting to SQL with enlist=true in the SQL Connection String or are you
using the SqlConnection.EnlistDistributedTransaction method?

Thanks,
Mark [MSFT] 

--
Please reply in newsgroup.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Steve" <pls2917 at mail.standarddomainsuffix> wrote in message
news:eOsKO9UBEHA.688@tk2msftngp13.phx.gbl...
> Hi All,
>
> I'm having a problem running distributed transactions from a middle tier
> server to a SQL Server.  I'm getting the following error when it attempts
to
> connect to SQL Server inside a transaction:
>
> [COMException (0x8004d00e): The transaction has already been implicitly or
> explicitly committed or aborted]
>
> I've researched other posts on this error and none of the resolutions seem
> to help in my case.  Some additional information:
>
> 1. All servers are running Windows Server 2003.  Database server is SQL
> Server 2000.
>
> 2. Servers are all standalone.  No domain involved.
>
> 3. NetBios name resolution works fine and I verified this using
DTCPING.EXE
>
> 4. I've checked the "Enable Network DTC Access" when adding the
application
> server to Windows Server 2003 on both computers.
>
> Any other ideas on things I may have missed?
>
>
>

Relevant Pages

  • Re: DCOM Error - Event 10009
    ... using SQL Server Management Studio 2005. ... Whenever we first launch SQL ... when connecting to a different registered server, it will hang again for 5 - ... I have checked DCOM Config using dcomcnfg, ...
    (microsoft.public.sqlserver.clients)
  • Re: Why is my _SERV_log.ldf file so big?
    ... take a look at the configuration in Enterprise Manager for your server. ... It's either on the server or on the databases themselves. ... you're doing then you should get your DBA to help with the SQL config. ... >> transaction log is turned on is to let it grow forever. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: MSDE on flash memory
    ... Therefore you may end up corrupting the transaction log in top level but still have some "old" ... I was wondering if it is considerable for you to move the DB on a server? ... I don't think MSDE has any "embedded" specific integration including flash random writing or etc. Keep in mind that MSDE on XPE ... I don't think SQL CE has any flash related issues fixed either. ...
    (microsoft.public.windowsxp.embedded)
  • Re: Heres a weird one for all of you...
    ... SQL: SQL 2005 Demo ... SQL 2005 Processor Licensed (connecting via port 14330) ... Additional Major S/W on that server: ... logs showed was an operation timeout error, ...
    (microsoft.public.sqlserver.connect)
  • Re: SqlTransactions and Sql timeout errors
    ... Basically the way transactions work in SQL Server is that the first ... commit the transaction. ... In committing the transaction, the server ... For example, if an Update statement fails in a batch, then SQL ...
    (microsoft.public.dotnet.framework.adonet)