Unable to Start SQL Server Agent

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

SSIS and Import/Export (2008)

Unable to Start SQL Server Agent

Author

Topic

sjokoro
Starting Member

5 Posts

Posted - 2010-11-16 : 22:58:19

When I try to start sql server agent from management studio, I get the following errors:

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.

Server stack trace:
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.FindObjectExplorerFrame()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.GetObjectExplorer(Boolean activateWindow)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ShowError(Exception e)
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)
================================

The error log copied from the log file viewer is:

Date,Source,Severity,Message
11/16/2010 21:12:00,,Information,[098] SQLServerAgent terminated (normally)
11/16/2010 21:12:00,,Error,[382] Logon to server '(local)' failed (DisableAgentXPs)
11/16/2010 21:12:00,,Error,[298] SQLServer Error: 18456<c/> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [SQLSTATE 28000]
11/16/2010 21:11:59,,Error,[000] Unable to connect to server '(local)'; SQLServerAgent cannot start
11/16/2010 21:11:59,,Error,[298] SQLServer Error: 18456<c/> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [SQLSTATE 28000]

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

When I attempt to start the service from configuration manager, the message is:

"This request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details."

I get the same message whether I try to log on to the service as Local system, local service or network service.

chadmat
The Chadinator

1974 Posts

Posted - 2010-11-16 : 22:59:57

What is the service account for SQLAgent?

-Chad

sjokoro
Starting Member

5 Posts

Posted - 2010-11-16 : 23:44:45

@Chad

The service account is NT SERVICE\SQLSERVERAGENT

-Sam

chadmat
The Chadinator

1974 Posts

Posted - 2010-11-17 : 00:27:24

Try resetting the password in configuration manager for the SQLAgent Service. Try setting it to Local System, see if it starts, then set it back to a domain account.

The error looks permission related to me.

-Chad

sjokoro
Starting Member

5 Posts

Posted - 2010-11-17 : 01:14:42

@Chad

I've tried it. There's no change

chadmat
The Chadinator

1974 Posts

Posted - 2010-11-17 : 01:35:34

It won't start even when set to Local System?

-Chad

sjokoro
Starting Member

5 Posts

Posted - 2010-11-17 : 02:24:05