SQL Server Performance

MSDTC

Discussion in 'SQL Server 2005 Clustering' started by viksar, May 7, 2007.

  1. viksar New Member

    We have cluster environment with 3 nodes. MSDTC is running, however I need to turn on logging for this. Can you please update how can we turn on this logging, are there any options available or paramters for turning on MSDTC.

    Also is this MSDTC reponsible for communication within SQL server??
  2. MohammedU New Member

    I don't think there is any way to logging MSDTC but it MSDTC has its own log in "c:WINDOWSsystem32MsDtc" folder...
    I don't think MSDTC is reponsible for communication within SQL Server...

    Start/Control panel/Adminitrative tools/componet services/computers/my computer/properties/MSDTC

    MS DTC exposes COM objects that allow clients to initiate and participate in coordinated transactions across multiple connections to a variety of data stores. To initiate a transaction, the SQL Native Client OLE DB provider consumer uses the MS DTC ITransactionDispenser interface. The BeginTransaction member of ITransactionDispenser returns a reference on a distributed transaction object. This reference is passed to the SQL Native Client OLE DB provider using JoinTransaction.

    MS DTC supports asynchronous commit and abort on distributed transactions.



    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. satya Moderator

    If MSDTC is not configured properly then you may get error 7391 while performing the simple queries. By default, where the MSDTC resources are installed depends on the operating system.http://support.microsoft.com/kb/899115 fyi

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  4. viksar New Member

    I was looking at this article, given below. We are having the same issue with SQL server where the cluster is restarting SQL server. There are no errors in CLuster or windows or sql logs. We have SQL server 2005 enterprise edition (No SP) on SAN discs AND its 32 bit environment. We thought it might be SAN , but no errors are reported on SAN as well.

    We have logged in case with Microsoft as well, and its been more than 2 weeks and they are still investigating on this. Reading this article it points to reinstalling MSDTC, before doing this I want to check for MSDTC logs, but there are none at this location. Any ideas???


    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=260557&p=1
  5. viksar New Member

    We are also getting errors before SQL server restart like

    The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection is re-established.


    SSPI handshake failed with error code 0x80090311 while establishing a connection with integrated security; the connection has been closed


    Error: 17806, Severity: 20, State: 2.

    There are just 2-3 threads on internet on this, but no solution...??
  6. MohammedU New Member

    Is there any reason not applying the service pack?

    Check the DTC security settings on the clustered DTC to make sure that 'DTC Network Access' is enabled along with 'Allow Inbound' Transaction communication and 'Allow Outbound' Transaction communication.

    Under what account DTC service is running?


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  7. satya Moderator

    SSPI handshake error caused due to any attempt with a login via their domain credentials that doesn't have relevant permission. Check under Event Viewer security log that should tell you username and machine information.

    http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/tkerberr.mspx on resolving the kerberos issues.

    Also see what other services are started on this SQL Server instance.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  8. MohammedU New Member

    One of my server had the similar issue but not cluster one...resolve using the following article...

    How to troubleshoot the "Cannot generate SSPI context" error message
    http://support.microsoft.com/kb/811889


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page