InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 05:06:15 GMT20http://www.sqlservercentral.com/Forums/Topic970191-146-1.aspxI have a similar problem on 1 of the servers i check ... any updates on your issue?Wed, 25 Aug 2010 02:41:55 GMTFeeghttp://www.sqlservercentral.com/Forums/Topic970191-146-1.aspxHey Win,So were you able to start the sql server agent ?Wed, 18 Aug 2010 23:17:34 GMTDivine Flamehttp://www.sqlservercentral.com/Forums/Topic970191-146-1.aspxI think this could be one of the reason that you are not able to start the sql server agent. Because every timne SQL Server agent starts it writes the entries in this file. Now if this file is being used by some other process which is not leting the sql server agent to use it for writing, SQL server agent may fail to start. Think so....:cool:Wed, 18 Aug 2010 05:53:32 GMTDivine Flamehttp://www.sqlservercentral.com/Forums/Topic970191-146-1.aspxWin,Did you try rebooting the system? Because normally you should be able to open this file always even if SQL Server Agent is started. if you have not rebooted it once, try to reboot in off peak hours if possible ;-)Wed, 18 Aug 2010 05:14:46 GMTDivine Flamehttp://www.sqlservercentral.com/Forums/Topic970191-146-1.aspxTried to open the SQLAGENT log file, but throws an [i]error as being used by another process..[/i]Wed, 18 Aug 2010 04:03:58 GMT- Win.http://www.sqlservercentral.com/Forums/Topic970191-146-1.aspx[size="3"][font="Times New Roman"]Hi Win.Did you check the entries in <Installation Dir$>\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLAGENT.OUT ?? It should contain the related error message. Hope this helps. :-)-Sujeet[/font][/size]Wed, 18 Aug 2010 03:54:33 GMTDivine Flamehttp://www.sqlservercentral.com/Forums/Topic970191-146-1.aspx[quote][b]- Win. (8/17/2010)[/b][hr]Hi Rohit,Tested all the things with accounts and permissions. Still no use...Its throwing the same error.- Win.[/quote]Have you tried with giving this account local admin rights to this server???Wed, 18 Aug 2010 03:43:14 GMTRamji29http://www.sqlservercentral.com/Forums/Topic970191-146-1.aspxThanks for your suggestion.I have already done the same , the rest of the instances are working fine with same accounts and processes done.also followed the article : http://support.microsoft.com/kb/322140- Win.Wed, 18 Aug 2010 02:24:21 GMT- Win.http://www.sqlservercentral.com/Forums/Topic970191-146-1.aspxAll username and password changes for the service accounts bound to SQL server services [u]must[/u] be updated via SQL server configuration manager!Wed, 18 Aug 2010 01:38:19 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic970191-146-1.aspxHi All,Thanks for your responses.We update the passwords manually using scripts..Changed password and tried again, but failed with the below error like:[b]The SQL Server Agent (XXX) serice failed to start due to the following error.Event ID : 7000the service did not respond tp start or control request in a timely fashion[/b]any more suggestions please....Tue, 17 Aug 2010 23:00:28 GMT- Win.http://www.sqlservercentral.com/Forums/Topic970191-146-1.aspx[quote][b]- Win. (8/17/2010)[/b][hr]And we updated the domain account and password [/quote]what tool did you use to update the service account username and password?Services snapinSQL Server Config ManagerTue, 17 Aug 2010 12:08:28 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic970191-146-1.aspxWinSince you're getting Logon to server 'REDMOND\XXXX' failed, I would guess that your SQL Server Agent doesn't have permission to log on. Have a look under Logins, and check that the SQL Server Account is there, or that a group of which it is a member is there. If you set up SQL Server to record failed logins then the login failure will also appear in the SQL Errorlog, along with the name of the login for which logon failed.JohnTue, 17 Aug 2010 06:55:54 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic970191-146-1.aspx[quote][b]- Win. (8/17/2010)[/b][hr]Hi,It was failed when server was rebooted. And we updated the domain account and password and tried restarting the services, but still it failed.....[b]Please find the below error log.[/b]2010-06-25 02:52:33 - ? [100] Microsoft SQLServerAgent version 9.00.4035.00 (x86 unicode retail build) : Process ID 51722010-06-25 02:52:33 - ? [101] SQL Server REDMOND\XXXX version 9.00.4035 (0 connection limit)2010-06-25 02:52:33 - ? [102] SQL Server ODBC driver version 9.00.40352010-06-25 02:52:33 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is REDMOND\XXXX 2010-06-25 02:52:33 - ? [310] 8 processor(s) and 4096 MB RAM detected2010-06-25 02:52:33 - ? [339] Local computer is REDMOND\XXXX running Windows NT 5.2 (3790) Service Pack 12010-06-25 02:52:33 - ? [432] There are 11 subsystems in the subsystems cache2010-06-25 02:52:35 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent2010-06-25 02:52:35 - ? [129] SQLAgent$REDMOND\XXXX starting under Windows NT service control2010-06-25 02:52:35 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect2010-07-05 11:49:16 - ? [130] SQLAgent$REDMOND\XXXX stopping because of Windows shutdown...2010-07-05 11:49:23 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004] 2010-07-05 11:49:23 - ! [382] Logon to server 'REDMOND\XXXX' failed (SaveAllSchedules)2010-07-05 11:49:32 - ! [359] The local host server is not running2010-07-05 11:49:32 - ? [098] SQLServerAgent terminated (normally)[/quote]See to be honest your log doesn't seems to be complete and of today's date (25th June & 5th July)... did you checked the logs after you did your tests just now???Tue, 17 Aug 2010 06:53:54 GMTRamji29http://www.sqlservercentral.com/Forums/Topic970191-146-1.aspxSQL Server Services are running fine with the same account.Tue, 17 Aug 2010 06:46:50 GMT- Win.http://www.sqlservercentral.com/Forums/Topic970191-146-1.aspxHi Rohit,Tested all the things with accounts and permissions. Still no use...Its throwing the same error.- Win.Tue, 17 Aug 2010 06:43:22 GMT- Win.http://www.sqlservercentral.com/Forums/Topic970191-146-1.aspx[quote][b]- Win. (8/17/2010)[/b][hr]Hi,It was failed when server was rebooted. And we updated the domain account and password and tried restarting the services, but still it failed.....[b]Please find the below error log.[/b]2010-06-25 02:52:33 - ? [100] Microsoft SQLServerAgent version 9.00.4035.00 (x86 unicode retail build) : Process ID 51722010-06-25 02:52:33 - ? [101] SQL Server REDMOND\XXXX version 9.00.4035 (0 connection limit)2010-06-25 02:52:33 - ? [102] SQL Server ODBC driver version 9.00.40352010-06-25 02:52:33 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is REDMOND\XXXX 2010-06-25 02:52:33 - ? [310] 8 processor(s) and 4096 MB RAM detected2010-06-25 02:52:33 - ? [339] Local computer is REDMOND\XXXX running Windows NT 5.2 (3790) Service Pack 12010-06-25 02:52:33 - ? [432] There are 11 subsystems in the subsystems cache2010-06-25 02:52:35 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent2010-06-25 02:52:35 - ? [129] SQLAgent$REDMOND\XXXX starting under Windows NT service control2010-06-25 02:52:35 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect2010-07-05 11:49:16 - ? [130] SQLAgent$REDMOND\XXXX stopping because of Windows shutdown...2010-07-05 11:49:23 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004] 2010-07-05 11:49:23 - ! [382] Logon to server 'REDMOND\XXXX' failed (SaveAllSchedules)2010-07-05 11:49:32 - ! [359] The local host server is not running2010-07-05 11:49:32 - ? [098] SQLServerAgent terminated (normally)[/quote]Does mssql service also running under this account??? just for testing purpose change the srvice account to local or add the service account to local admin (although its not recommended) but this will confimr if this is due to any permissions issues.... secondly have u added this new domain login for having "log on as service" rights??Tell me if this helps.RohitTue, 17 Aug 2010 06:22:08 GMTRamji29http://www.sqlservercentral.com/Forums/Topic970191-146-1.aspxAny suggestions please..........Tue, 17 Aug 2010 04:00:22 GMT- Win.http://www.sqlservercentral.com/Forums/Topic970191-146-1.aspxHi,It was failed when server was rebooted. And we updated the domain account and password and tried restarting the services, but still it failed.....[b]Please find the below error log.[/b]2010-06-25 02:52:33 - ? [100] Microsoft SQLServerAgent version 9.00.4035.00 (x86 unicode retail build) : Process ID 51722010-06-25 02:52:33 - ? [101] SQL Server REDMOND\XXXX version 9.00.4035 (0 connection limit)2010-06-25 02:52:33 - ? [102] SQL Server ODBC driver version 9.00.40352010-06-25 02:52:33 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is REDMOND\XXXX 2010-06-25 02:52:33 - ? [310] 8 processor(s) and 4096 MB RAM detected2010-06-25 02:52:33 - ? [339] Local computer is REDMOND\XXXX running Windows NT 5.2 (3790) Service Pack 12010-06-25 02:52:33 - ? [432] There are 11 subsystems in the subsystems cache2010-06-25 02:52:35 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent2010-06-25 02:52:35 - ? [129] SQLAgent$REDMOND\XXXX starting under Windows NT service control2010-06-25 02:52:35 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect2010-07-05 11:49:16 - ? [130] SQLAgent$REDMOND\XXXX stopping because of Windows shutdown...2010-07-05 11:49:23 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004] 2010-07-05 11:49:23 - ! [382] Logon to server 'REDMOND\XXXX' failed (SaveAllSchedules)2010-07-05 11:49:32 - ! [359] The local host server is not running2010-07-05 11:49:32 - ? [098] SQLServerAgent terminated (normally)Tue, 17 Aug 2010 02:55:11 GMT- Win.http://www.sqlservercentral.com/Forums/Topic970191-146-1.aspxHi..Can you plz provide more info on this as.... what exactly happen when the agent wasn't starting?? was it crashed or machine was rebooted or services were rebooted.... plz post the sql error log and sql server entries from event viewer...Tue, 17 Aug 2010 02:48:34 GMTRamji29http://www.sqlservercentral.com/Forums/Topic970191-146-1.aspxExperts,Greetings for the day...!!I have severe problem, please help me to fix this.I have a box which is with SQL 2005 EE + SP3 updated on Win 2003 + SP2.Suddenly SQL Server agent failed to start, Log has no such cause and information other than agent shutdown.....[b]---------------------------WMI Provider Error---------------------------The service did not respond to the start or control request in a timely fashion. [0x8007041d]---------------------------OK ---------------------------cmd:The application failed to initialize properly (0xc0000005). Click on OK to terminate the application.[/b]No where found the resolution for this..Can anyone have any ideas...??Fast help appreciated...Thanks,- Win.Tue, 17 Aug 2010 02:34:16 GMT- Win.