SQLSERVERAGENT Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

SQLSERVERAGENT Error

Author

Topic

sathishmadhav
Starting Member

8 Posts

Posted - 2014-01-22 : 06:49:52

Hi all

I am on SQL SERVER 2008R2, my issue "unable to start SQL AGENT". please see below error message popping up while trying to start Agent service. Any one has a clue pls help me.

thanks
satish

===================================

Unable to start service SQLSERVERAGENT on server BANARLYSERVER. (mscorlib)

------------------------------
Program Location:

Server stack trace:
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ServiceActionHandler.EndInvoke(IAsyncResult result)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ServiceControlProgress.ActionCompletedHandler(IAsyncResult result)

===================================

Service Request Timeout (ObjectExplorer)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.CheckServiceActionReturnValueSuccess(UInt32 returnValue)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-01-22 : 07:34:22

Check the value of key ErrorLogFile in the following registry hive and confirm if it is pointing to the correct location
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\SQLServerAgent

Javeed Ahmed

sathishmadhav
Starting Member

8 Posts

Posted - 2014-01-28 : 04:26:13

Hi Ahmed

Value key of ErrorLogFile shows :"C:\Program Files\Microsoft SQL Server\MSSQL10_50.BANARLYSQL\MSSQL\Log\SQLAGENT.OUT"

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-01-28 : 06:46:14

browse to that location and check if you have SQLAGENT.OUT file there.

Javeed Ahmed

sathishmadhav
Starting Member

8 Posts

Posted - 2014-01-28 : 08:09:20

No File not found in that path

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-01-28 : 08:22:19

so,thats the issue..check out where the file SQLAGENT.OUT actually residing.Then update the registry value with the correct path.

Javeed Ahmed

sathishmadhav
Starting Member

8 Posts

Posted - 2014-01-28 : 08:29:54

I cannot find this file anywhere only my system

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-01-28 : 08:33:19

can you see the sqlagent service under services?

Javeed Ahmed

sathishmadhav
Starting Member

8 Posts

Posted - 2014-01-28 : 08:35:52

Yes i can see SQLSERVERAGENT, Display Name: SQL Server Agent (MSSQLSERVER), Startup type:Manual

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-01-28 : 08:36:45

are you having multiple instances on your system?

Javeed Ahmed

sathishmadhav
Starting Member

8 Posts

Posted - 2014-01-28 : 08:42:15

Humm, how to correct it

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-01-28 : 08:45:07

As far as i know the solution is ,you need to point out the correct location and update the registry value.
Someone else might be able to help you

Javeed Ahmed

sathishmadhav
Starting Member

8 Posts

Posted - 2014-01-28 : 08:46:23

point out to correct location SQLAGENT.OUT ??

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-01-28 : 08:47:30

yes

Javeed Ahmed

sathishmadhav
Starting Member

8 Posts

Posted - 2014-01-28 : 08:50:14

OK.. thanks Javeed. I appreciate your help