InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 05:36:34 GMT20http://www.sqlservercentral.com/Forums/Topic1165745-146-1.aspxHi Sai,Can you please let us know what was the output of the Case with Microsoft, was there solution for your problem?ThanksTue, 15 Jan 2013 22:22:58 GMTBob Bogdanovic-469359http://www.sqlservercentral.com/Forums/Topic1165745-146-1.aspxAjay,Msdb database is running fine Joie,I have tried to startup sevrices under domain account as well as local system account.All our services run under one domain account a a standardI will look into the article.Also opened an incident with microsoft technical support .Will keep posted with any updates as i receive .Thanks,Sai Thu, 01 Sep 2011 12:48:33 GMTSaidba17http://www.sqlservercentral.com/Forums/Topic1165745-146-1.aspxThe clue to the problem might just be in the error message[quote][097] Memory leak detected [204 bytes]Exception 5 caught at line 403 of file e:\sql9_sp2_t\sql\komodo\src\core\sqlagent\src\alerter.cpp. SQLServerAgent [/quote]My reading of the message is that SQL Agent has detected a memory leak in a third-party component called alerter.cpp. This could be supplied with the komodo ide or be a locally developed product. Try Googling 'Mark Russinovich memory leak' for a step by step guide on how to detect if a memory leak is happening and the module causing it.Wed, 31 Aug 2011 03:18:15 GMTEdVassiehttp://www.sqlservercentral.com/Forums/Topic1165745-146-1.aspxIf nothing is reported in the SQL error log when the instance starts have you tried just making changes just to the SQL Agent service through SQL Server Configuration Manager to start eliminating possibilities? Tried setting the SQL Agent to use the local system account? Set the agent to use a new domain account? A new local account?Tue, 30 Aug 2011 16:00:02 GMTJoie Andrewhttp://www.sqlservercentral.com/Forums/Topic1165745-146-1.aspxIs msdb database working fine?Tue, 30 Aug 2011 01:34:08 GMTAjay...http://www.sqlservercentral.com/Forums/Topic1165745-146-1.aspxThey were few errors in the .Notified windows admins to look into the logs .Event Logs :The description for Event ID '0' in Source '' cannot be found. The local computer may not have the necessary registry information or message DLL files to display the message, or you may not have permission to access them.Yes,Account has sysadmin rights.Both Sql Server services and agent are running through the same domain account .I dont have any issues with the Sql server services.Everything was running fine untill the server was rebooted few days ago . Thanks,SaiMon, 29 Aug 2011 08:40:22 GMTSaidba17http://www.sqlservercentral.com/Forums/Topic1165745-146-1.aspxThrough which account your agent service is running.check that account has sysadmins rights?Mon, 29 Aug 2011 04:06:17 GMTMasterDBhttp://www.sqlservercentral.com/Forums/Topic1165745-146-1.aspxAre there any entries in the logs? Start with the SQL Error Logs and then move to the Windows Logs.Fri, 26 Aug 2011 10:12:24 GMTMeet George Jetsonhttp://www.sqlservercentral.com/Forums/Topic1165745-146-1.aspxHi all,I have been seeing a strange issues.We have a Sql server 2005 Enteprise edition installed on a windows 2008 server.Sql server agent stopped working suddenly and this issue started since the last couple of days .Tried to start it up but shutdowns immediatley.We have 32 gb of Ram and 16 cpu's allocated.I dont see any issues with the Sql Server services Sql Agent Output file [097] Memory leak detected [204 bytes]Exception 5 caught at line 403 of file e:\sql9_sp2_t\sql\komodo\src\core\sqlagent\src\alerter.cpp. SQLServerAgent initiating self-terminationPlease share your suggestionsThanks,Sai Thu, 25 Aug 2011 14:31:28 GMTSaidba17