Post reply

2008 R SQL agent won't start

  • August 11, 2011 at 4:32 pm

    #241955

    I am completely baffled by this one. I've got a brand new install of SQL Server 2008 R2 SP1, standard edition, 64 bit. SQL Agent will not start. I tried the following:

    sp_configure 'show advanced options', 1;

    GO

    RECONFIGURE;

    GO

    sp_configure 'Agent XPs', 1;

    GO

    RECONFIGURE

    GO

    I can then look at the configuration and verify that the Agent XPs setting is set to 1. Then I try to start SQL Agent. It tries, then comes back with an error saying it could not be started. When I looked at the Agent XPs settings again, it has reverted back to 0.

    There is nothing in the SQL Agent log - in fact, a new Agent logfile is not even created. (The account has permissions to write to the log directory because the SQL service runs under the same account and it can write the SQL error log there.) There is nothing in the SQL log nor the Windows event logs. When I try to start the service, I get a message back saying it started then stopped.

    Any ideas?

  • August 11, 2011 at 4:58 pm

    #1367654

    What OS?

    Also, which Event Log did you check (system, application)?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 11, 2011 at 5:39 pm

    #1367665

    This is Windows server 2008. Checked both the app and system logs.

  • August 12, 2011 at 8:22 am

    #1367955

    Just to document.. I found the solution. I performed both steps listed in the second solution at http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/ee918522-2190-4d5e-9e25-a8ae34ced025/

    Turns out the SQL Server service account was not a member of the SqlServerSqlAgentUser$SERVER$INSTANCE security group and it also did not have any permissions on the registry key listed.

    How did this happen? Well, during the initial install, a coworker was applying windows patches and rebooted the machine. After it came back up, I did an uninstall of SQL and re-installed, but I guess things were still messed up.

  • August 12, 2011 at 9:36 am

    #1368018

    Thanks for getting back with what worked.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 5 posts - 1 through 4 (of 4 total)

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