Cannot start SQLSERVERAGENT

Question

Cannot start SQLSERVERAGENT

bubby

SSCertifiable

Points: 5638
More actions
December 3, 2012 at 12:02 pm

#267092

===================================
Unable to start service SQLSERVERAGENT on server ISLRPTSQL. (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)
===================================
The SQLSERVERAGENT service on ISLRPTSQL started and then stopped. (ObjectExplorer)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 1

Have tried changing the startup account of the service? Try an admin account and confirm if the service starts fine. After that check for missing permissions.

Jayanth Kurup[/url]

bubby SSCertifiable Points: 5638 More actions · Answer 2

Permission is not the issue, as this account is local admin and sql system admin account other jobs are running fine with this account, I tried another power account too to make sure

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

Sometimes this requires a full restart of the box, but I would check the eveny log to see if there is additional detail being logged such as a login failure.

CEWII

bubby SSCertifiable Points: 5638 More actions · Answer 4

SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

This is what I see in event veiwer nothing else,

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 5

So the issue is it can't connect to the SQL Server. I'm gonna be silly and ask whether you have verified that the SQL server is running..

If so then I think you are stuck with having to do a restart of the machine, you could try a SQL restart first but I'm not hopeful.

CEWII

bubby SSCertifiable Points: 5638 More actions · Answer 6

Resolution: I tried copying few corrupted files that did not fix the proble,,

I re-installedthe service pack 2 for SQL server 2008 R2 64 bit and then rebooted the server that fixed the problem,

Had to wait till end of the day to troubleshoot as had to reboot the server few times,

Cheer!!!!!

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 7

Glad to hear you worked it out but I believe it would have been beneficial to state that a service pack was in play..

CEWII

bubby SSCertifiable Points: 5638 More actions · Answer 8

This all problems started when I had RTM version for SQL version and upgraded to SP2,

Thanks

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 9

Precisely my point, I looked back just to see if I missed it. That imformation would have changed the path suggested.

CEWII