SQL Server Performance Forum – Threads Archive
Could not start Sqlserver Agent.
I’m getting this error when the agent tries to start. I’ve rebooted the server, tried using a different login for the service, but it will not allow me to start it. The complete error is below: could not start the sqlserveragent service on <sqlservername>.The service did not return an error. This could be an internal windows error or an internal service error. If the problem persists, contact your system administrator. Any ideas ? Thanks,
Gopal
This started happening only after we install the latest Windows Update. It was working fine before the windows update. Thanks,
Gopal
What about to reinstall SQL or last SQL SP? Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
Have you checked the error log of the agent? It might have a more specific message? Right-Click on SQL Server Agent in Enterprise Manager and choose Error Log… Cheers
Twan
Check whether your instance fall in this category: [KBA]http://support.microsoft.com/default.aspx?scidhttp://support.microsoft.com:80/support/kb/articles/Q302/4/09.ASP&NoWebContent=1
If the Certificate Server is installed on a Microsoft Windows 2000 computer and the Certificate Authority (CA) name is the same as or starts with the machine host name, an attempt to connect to SQL Server 2000 fails. The SQLServerAgent service also fails with the following error message: Could not start SQLserverAgent Service on local computer. The service did not return an error. This could be an internal Windows error or an internal service error. If this error persists, contact your system administrator. Due to the same connectivity errors indicated previously, an attempt to install Microsoft SQL Server 2000 may also fail. And make sure the password has not changed for the SQL service accounts recently.
Set ‘Password never expires’ for the NT account used to start SQL Services. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Great Sathya. I think this should solve the problem. I am going to try this evening. I will post you later. Thanks,
Gopal
Also you can right click on sql server agent in Enterprize manager –>><img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />roperties–>>General Tab–>>FileName<br /><br />check the path under file name.It might not exist.I had problems with starting sql server agent because that path was incorrent.And there was no recors in event log about cause of that failure.
I am sorry, I posted a new posting instead of reply. Is it possible for anyone to delete the new posting or to add to this posting.
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2018 Thanks,
Gopal
This is the extract of other post by Gopal :
FYI – When I tried to restart the sql agent manually before, there is no entry in the Event log nor in sql error log. I followed the procedures given in microsoft website. I think the problem is solved now. I ran the command
certutil -key This uses the same logon account as the sql agent logon account. I removed by using the command
certutil -delkey and sqlagent started and it is working fine. I have been updating windows update for quite long time and I am not sure why it is happening now. Thanks to everyone,
Gopal
You can do it yourselves by editing the current post and cut/paste the new topic. I’ve deeleted the other post.
Anyway glad to know problem solved. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>