Ms Sql Error 17052
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: SQL Server Event ID 17052: SQLServerAgent has terminated unexpectedly. SQL Server > SQL Server Database Engine Question 0 Sign in to vote Hello All, We are getting EventID17052 in one of our production server from last 3 months. SQL Server Agent is restarting on its own. As per threads about same issue I dig into the Jobs and processes running at that time in Server and I have found one job is causing this issue and Agent crash is happening same time that job is scheduled but not everyday. Server is running with SQL Server 2005 SP2 (Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1) ). Please let me know is there any fix for this error and also let me know SP3 upgrade to SQL Server 2005 will help for it or not? I am also providing full error details from event viewer. The description for Event ID 17052 from source MSSQLSERVER cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: SQLServerAgent Monitor: SQLServerAgent has terminated unexpectedly. the message resource is present but the message is not found in the string/message table - System - Provider [ Name] MSSQLSERVER - EventID 17052 [ Qualifiers] 16384 Level 2 Task 2 Keywords 0x80000000000000 - TimeCreated [ SystemTime] 2010-09-05T10:21:31.000Z EventRecordID 137838 Channel Application Computer IPRDDB130.IKAPROD90.COM Security - EventData SQLServerAgent Monitor: SQLServerAgent has terminated unexpectedly. A80100000A0000001400000049005000520044004400420031003300300000000E0000006D00610073007400650072000000 Binary data: In Words 0000: 000001A8 0000000A 00000014 00500049 0008: 00440052 00420044 00330031 00000030 0010: 0000000E 0061006D 00740073 007200
Analyzer Sample report Advanced filtering Direct links to www.eventid.net Email notifications Scheduled reporting Free for subscribers EventReader Event Viewer Sample report Custom views/filters Servers list, organized in groups Integration with EventID.Net Consolidated view for all logs Free for subscribers Event ID: 17052 Source: MSSQLServer Source: MSSQLServer Type: Error Description:Error:
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn http://dba.stackexchange.com/questions/117855/trouble-shooting-unable-to-complete-login-process more about Stack Overflow the company Business Learn more about hiring developers or posting https://www.experts-exchange.com/questions/27220158/Event-ID-17052-Source-MSSQL-database.html ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ms sql ask a question Anybody can answer The best answers are voted up and rise to the top Trouble Shooting “Unable to complete login process” up vote 0 down vote favorite Issue On one of our SQL Server witness servers (This is part of our Database Mirroring setup for SQL Server 2008 R2) we have just started getting the below event in the windows event log. The description for Event ms sql error ID 17052 from source MSSQLSERVER cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: Severity: 16 Error:0, OS: 0 [Microsoft][SQL Server Native Client 10.0]Unable to complete login process due to delay in opening server connection the message resource is present but the message is not found in the string/message table These events are happening at varying times and so far we have had 22 errors starting on 27/08/2015. I have looked through our change log and I can't see any changes for that day that look relevant. I have done some investigation and found the following article. This looks at the xml information in the below table; however none of the events in the result set correspond to the times of any of the failures. SELECT CAST(record as xml) as record FROM sys.dm_os_ring_buffers WHERE ring_buffer_type = 'RING_BUFFER_CONNECTIVITY' To make matters worse the errors seem sporadic with no determinable pattern. Question How can I find out w
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Event ID 17052 Source MSSQL database Want to Advertise Here? Solved Event ID 17052 Source MSSQL database Posted on 2011-07-25 MS SQL Server 1 Verified Solution 4 Comments 1,476 Views Last Modified: 2012-05-11 Folks revieveing a bunch of these warnings over teh last couple of days on my SQL server. its a Win2003 & SQL 2000 SP4 Event Type: Error Event Source: MSSQL$ Event Category: (2) Event ID: 17052 Date: 25/07/2011 Time: 16:12:11 User: NT AUTHORITY\SYSTEM Computer: SERV02 Description: Error: 9001, Severity: 21, State: 1 The log for database 'tempdb' is not available. When i reboot it clears up, but that follows on from what i've read in that temp.db is recreated after a reboot/service restart. there's no disk space shortage, the drive is question has 20+GB free. the server itself is a virtual server running on VMWare and none of the other VMs are showing any signs of issues 0 Question by:faolchu Facebook Twitter LinkedIn Google LVL 5 Best Solution byVENKAT KOKULLA Even though the drive has enough space the processess demanding more log space on TEMPDB and amount of time SQL is taking to increase the size is the main issue. So you have to limit the number of processess Go to Solution 4 Comments LVL 15 Overall: Level 15 MS SQL Server 3 Message Expert Comment by:pateljitu2011-07-25 Looks like corruption issue, have a look at these links: http://www.sql-server-performance.com/forum/threads/troubleshooting-problem.9521/ http://support.microsoft.com/default.aspx?scid=kb;EN-US;838765 0 LVL 8 Overall: Level 8 MS SQL Server 6 Message Expert Comment by:Andrei Fomitchev2011-07-25 use tempdb go sp_h