Can't Start SQL Server Agent service

Posted on 2009-12-17
Last Modified: 2012-05-08
I am unable to start the SQL Server Agent service on SQL Server 2008.  The error message I get when I try to start the service is "Object reference not set to an instance of an object"

Thanks for your help.
Question by:les28
    LVL 13

    Expert Comment

    Look at SQLAGENT.OUT in the ERRORLOG directory where SQL is installed.

    LVL 3

    Expert Comment

    What were you doing when this error occurred?  Where you trying to install something?
    LVL 13

    Expert Comment


    Can you stop the SQL server. Restart it. Login to SQLSERVERAGENT service with admin ID. Check if it restarts. If not, please post the log/messages.

    LVL 1

    Author Comment

    The database has been re-installed - the previous one choked on updating to sp1, so I uninstalled and reinstalled.

    I did have a problem as per

    I also tried changing the security policy as per -- adding the domain admins group.

    I thought that this had been resolved -- refreshing after running the script doesn't show agentXP disabled anymore.  After attempting to start the server agent service however, the problem returns.

    I have tried enabling the service through facets - server configuration with the same result.

    SQL Agent out copied below.

    Thanks everyone for responding:
    2009-03-02 15:00:27 - ? [393] Waiting for SQL Server to recover databases...
    2009-03-02 15:00:49 - ? [100] Microsoft SQLServerAgent version 10.0.1600.22 ((Unknown) unicode retail build) : Process ID 2872
    2009-03-02 15:00:49 - ? [101] SQL Server MTI-2VM version 10.00.1600 (0 connection limit)
    2009-03-02 15:00:49 - ? [102] SQL Server ODBC driver version 10.00.1600
    2009-03-02 15:00:49 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is
    2009-03-02 15:00:49 - ? [310] 1 processor(s) and 3999 MB RAM detected
    2009-03-02 15:00:49 - ? [339] Local computer is MTI-2VM running Windows NT 6.0 (6001) Service Pack 1
    2009-03-02 15:00:50 - ? [432] There are 12 subsystems in the subsystems cache
    2009-03-02 15:00:51 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
    2009-03-02 15:00:51 - ? [129] SQLSERVERAGENT starting under Windows NT service control
    2009-03-02 15:00:51 - + [260] Unable to start mail session (reason: No mail profile defined)
    2009-03-02 15:00:51 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
    2009-03-02 15:06:59 - ? [131] SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS...
    2009-03-02 15:07:01 - ? [098] SQLServerAgent terminated (normally)
    LVL 13

    Accepted Solution

    LVL 3

    Expert Comment

    Try installing the SQL 2000 tools and restart the service.  It sounds weird but Microsoft says it will fix it.
    LVL 1

    Author Closing Comment

    Changing the user that the service runs under worked.  Thanks.

    Now that I have resolved this, I find I can't create maintenance plans.  (Which was one of the problems that prompted the first reinstall)

    I have posted it as a separate question:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now