SQL Server Agent refuses to start

Posted by Geo Ego on Server Fault See other posts from Server Fault or by Geo Ego
Published on 2010-05-20T16:17:52Z Indexed on 2010/05/20 16:20 UTC
Read the original article Hit count: 378

I'm having a problem with SQL Server 2005 where the SQL Server Agent suddenly refuses to start. If I attempt to start it through Services, I get the error "SQL Server Agent (MSSQLSERVER) service on Local Computer started and then stopped." In the Application log, I have the following entry:

Event Type: Error
Event Source:   SQLSERVERAGENT
Event Category: Service Control 
Event ID:            103
Date:       5/20/2010
Time:       11:07:07 AM
User:       N/A
Computer:            SHAREPOINT
Description:
SQLServerAgent could not be started (reason: Unable to connect to server 'SHAREPOINT'; SQLServerAgent cannot start).

This database has been running fine for four months. It contains a SharePoint configuration database, which two days ago stopped working, throwing me a message that the configuration database cannot be reached. It was then that I realized the SQL Server Agent was not running, and I have been unable to restart it. I have tried running it with both the local system account and the network service account, with the same results. So far, I have tried:

  • Granting the administrators group, network service, and SharePoint SQL Server Agent account public and sysadmin roles on the database.
  • Granting the administrators group, network service, and SharePoint SQL Server Agent account full permissions to the entire MSSQL directory and all files within.

I still have no joy.

© Server Fault or respective owner

Related posts about sql-server-2005

Related posts about sqlserveragent