SQL Server Performance Forum – Threads Archive

MSDTC

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??

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.

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.

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

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…??

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.

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.

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.

]]>