Error when enlisting in a distributed transaction - DOTNET

This is a discussion on Error when enlisting in a distributed transaction - DOTNET ; Hi I'm using ServiceConfig class for handling across component transactions. My .Net application is running on windows 2003 server. database is SQLServer. The application works fine if the SQLServer is running on the same server where my application is running. ...

+ Reply to Thread
Results 1 to 2 of 2

Error when enlisting in a distributed transaction

  1. Default Error when enlisting in a distributed transaction

    Hi

    I'm using ServiceConfig class for handling across component
    transactions. My .Net application is running on windows 2003 server.
    database is SQLServer. The application works fine if the SQLServer is
    running on the same server where my application is running. If I try to
    access a SQLServer which is running on a remote server, I get the
    folowing error.

    An error occurred while enlisting in a distributed transaction. at
    System.Data.SqlClient.SqlInternalConnection.EnlistNonNullDistributedTran
    saction(ITransaction transaction)
    at
    System.Data.SqlClient.SqlInternalConnection.EnlistDistributedTransaction
    (ITransaction newTransaction, Guid newTransactionGuid)
    at
    System.Data.SqlClient.SqlInternalConnection.EnlistDistributedTransaction
    ()
    at System.Data.SqlClient.SqlInternalConnection.Activate(Boolean
    isInTransaction)
    at System.Data.SqlClient.SqlConnection.Open()

    The MSTDTC is running on the remote server. I set the Security
    configuration for the components services where application is running
    as "No Authentication Required"
    (ComponentServices-MyComputer->Properties->MSTDC->SecurityConfiguration)
    . With this change the application could run. But I'm not sure if this
    is the right way to overcome the authentication issue. Any better
    approach please?

    Regards




    *** Sent via Developersdex http://www.developersdex.com ***

  2. Default Re: Error when enlisting in a distributed transaction

    The different ways in which you can configure MSDTC are described at
    http://blogs.msdn.com/florinlazar/ar...18/159127.aspx

    Regards,
    --
    Florin Lazar - Microsoft - [ http://blogs.msdn.com/florinlazar ]
    Please do not send email directly to this alias. This alias is for newsgroup
    purposes only.
    This posting is provided "AS IS" with no warranties, and confers no rights.


    "RJN" <rjn@yahoo.com> wrote in message
    news:ukmhLIurFHA.3392@TK2MSFTNGP11.phx.gbl...
    Hi

    I'm using ServiceConfig class for handling across component
    transactions. My .Net application is running on windows 2003 server.
    database is SQLServer. The application works fine if the SQLServer is
    running on the same server where my application is running. If I try to
    access a SQLServer which is running on a remote server, I get the
    folowing error.

    An error occurred while enlisting in a distributed transaction. at
    System.Data.SqlClient.SqlInternalConnection.EnlistNonNullDistributedTran
    saction(ITransaction transaction)
    at
    System.Data.SqlClient.SqlInternalConnection.EnlistDistributedTransaction
    (ITransaction newTransaction, Guid newTransactionGuid)
    at
    System.Data.SqlClient.SqlInternalConnection.EnlistDistributedTransaction
    ()
    at System.Data.SqlClient.SqlInternalConnection.Activate(Boolean
    isInTransaction)
    at System.Data.SqlClient.SqlConnection.Open()

    The MSTDTC is running on the remote server. I set the Security
    configuration for the components services where application is running
    as "No Authentication Required"
    (ComponentServices-MyComputer->Properties->MSTDC->SecurityConfiguration)
    With this change the application could run. But I'm not sure if this
    is the right way to overcome the authentication issue. Any better
    approach please?

    Regards




    *** Sent via Developersdex http://www.developersdex.com ***



+ Reply to Thread

Similar Threads

  1. "An error occurred while enlisting in a distributed transaction."
    By Application Development in forum DOTNET
    Replies: 0
    Last Post: 07-11-2006, 08:59 AM
  2. distributed transaction from outside into domain
    By Application Development in forum DOTNET
    Replies: 0
    Last Post: 06-18-2006, 06:29 AM
  3. Enterprise services - error enlisting in distributed transaction
    By Application Development in forum DOTNET
    Replies: 0
    Last Post: 05-10-2005, 12:54 PM
  4. Re: distributed transaction problem
    By Application Development in forum DOTNET
    Replies: 1
    Last Post: 04-02-2004, 04:18 PM
  5. How to perform distributed transaction for two classes?
    By Application Development in forum DOTNET
    Replies: 2
    Last Post: 02-16-2004, 04:47 AM