September 3, 2010 at 3:16 am
This is a standalone SQL Server 2008 sp1 64 bit Standard Ed. instance running on Windows 2003 64bit. This was in the SQL errorlog just prior to the Agent being forced offline. I haven't seen much on these errors when performing a google search. Can anyone shed some light on this and why the Agent would be shut down?
2010-09-02 03:59:20.91 spid165 Microsoft Distributed Transaction Coordinator (MS DTC) BEGIN TRANSACTION failed: 0x8007000e(Not enough storage is available to complete this operation.).
2010-09-02 03:59:20.99 Logon Error: 17827, Severity: 20, State: 1.
2010-09-02 03:59:20.99 Logon There was a failure while attempting to encrypt a password. The connection has been closed. [CLIENT: 10.X.X.X]
2010-09-02 03:59:20.99 Logon Error: 17827, Severity: 20, State: 1.
2010-09-02 03:59:20.99 Logon There was a failure while attempting to encrypt a password. The connection has been closed. [CLIENT: X.X.X.X]
2010-09-02 03:59:21.04 Logon Error: 17827, Severity: 20, State: 1.
2010-09-02 03:59:21.04 Logon There was a failure while attempting to encrypt a password. The connection has been closed. [CLIENT: X.X.X.X]
2010-09-02 03:59:21.04 Logon Error: 17827, Severity: 20, State: 1.
2010-09-02 03:59:21.04 Logon There was a failure while attempting to encrypt a password. The connection has been closed. [CLIENT: X.X.X.X]
2010-09-02 03:59:25.21 spid244 Error: 8518, Severity: 16, State: 3.
2010-09-02 03:59:25.21 spid244 Microsoft Distributed Transaction Coordinator (MS DTC) BEGIN TRANSACTION failed: 0x8007000e(Not enough storage is available to complete this operation.).
2010-09-02 03:59:25.21 spid157 Error: 8518, Severity: 16, State: 3.
2010-09-02 03:59:25.21 spid157 Microsoft Distributed Transaction Coordinator (MS DTC) BEGIN TRANSACTION failed: 0x8007000e(Not enough storage is available to complete this operation.).
2010-09-02 03:59:25.30 spid372 Error: 8510, Severity: 20, State: 3.
2010-09-02 03:59:25.30 spid372 Enlist operation failed: 0x8004d100(XACT_E_CONNECTION_REQUEST_DENIED). SQL Server could not register with Microsoft Distributed Transaction Coordinator (MS DTC) as a resource manager for this transaction. The transaction may have been stopped by the client or the resource manager.
2010-09-02 04:00:09.76 Logon Error: 18452, Severity: 14, State: 1.
2010-09-02 04:00:09.76 Logon Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: 171.X.X.X]
2010-09-02 04:00:11.43 Logon Error: 18452, Severity: 14, State: 1.
2010-09-02 04:00:11.43 Logon Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: X.X.X.X]
2010-09-02 04:01:02.39 spid89 Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
September 30, 2011 at 1:15 pm
you ever figure out what caused this msdtc error?
September 30, 2011 at 1:37 pm
Brian-444611 (9/30/2011)
you ever figure out what caused this msdtc error?
Seems like it's there in the second line: (Not enough storage is available to complete this operation.).
a disk is full where DTC is running?
September 30, 2011 at 9:58 pm
Sounds like you have a REALLY large transaction attempting to be committed and you either have your tempdb and ldf files sitting on a disk that's just about out of space...
I don't suppose you have any of your SQL files sitting on your C:\ drive do you?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 1, 2011 at 9:07 pm
we are getting the same error and our tempdb does not fill and there is plenty of space (hundreds of GBs) on disk w/ all files set to autogrow in case we ever dont grow them in advance.
i found an interesting article on a 10 minute timeout on C# system.transactions namespace for enlisted transactions. the client is the one aborting in our case. we just have to figure out why and it may be the timeout.
October 2, 2011 at 7:55 pm
Apply latest service pack for SQL and check if theissue still persist.
October 3, 2011 at 6:54 pm
bipan, that is some of the crappiest advice i have ever heard.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply