Post reply

SQL Server Agent would not start

  • September 27, 2006 at 11:36 am

    #367501

    Hi..

    I changed min memory setting on my SQL Server 2005 instance running on a 64-bit environment this morning and rebooted the service.  Since then my Agent refuses to start.

    The event log gives me the following error message: “SQLServerAgnet 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).”

     The Agent is set to run under an NT account (same as SQL Service), which belongs to sysadmin group on SQL Server as well as Administrators group on the box.

     Any advices would be greatly appreciated! 

    Thank you!

    Anastasia

  • September 28, 2006 at 1:56 pm

    #663137

    Try rebooring the server. I've found that when there are problems authenticating a Windows login and SQL Server is claiming that the user is Null or unknown, then rebooting the server will fix it.

    You could also try changing the sql agent account to somethign else and then changing it back if you don't want to reboot.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

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

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