Post reply

SQL Server Agent won''t start

  • June 7, 2006 at 5:37 pm

    #117929

    Hello all,

    I am unable to get SQL Server Agent to start. This is for SQL Server 2005 Enterprise Edition, on a fresh install. I am running WIN2k3 servers with active directory. I am using the same Domain account for all services; this account has 'Enterprise Admin' and 'Domain Admin' membership. All services start except the SQL Server Agent using this account. If I change the SQL Server to start as 'Local Account', and SQL Server agent the same, all is good, otherwise I get a timeout trying to start the Agent. The Active Directory account mentioned above has been added to the SQL Server Security list with sysadmin role. The Protocols are all set to  both TCP/IP and Named Pipes. Any thoughts?

     The event viewer application error I receive is:

    SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the SysAdmin role).

     

    Thanks in Advance,

    Kirk

     

     

  • June 8, 2006 at 7:57 am

    #642539

    Can you check SQL agent properties-->Connection? You can try to change to use a SQL account (member of sysadmin)to connect to SQL server.

     

  • June 8, 2006 at 4:27 pm

    #642675

    Peter(?),

    Thanks for the prompt reply. I have determined that running the SQL Server as 'LocalSystem' does not cause any problems, and doing so resolved the problem. I do have the rest of the components running under the domain account with no problem.

     

    Thanks again,

    Kirk

     

Viewing 3 posts - 1 through 3 (of 3 total)

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