• Joie Andrew (8/7/2013)


    When you try and start the SQL Agent service under a local account and it fails do you get any logon failures in the security log in Event Viewer? If so can you post them? Also, can you verify that the local account that you want to start the service as has the "Log on as a Service" right? This should have been set when you configure the account in SQL Server Configuration Manager, but it is possible that this did not happen.

    It used to say access denied. It now says: The SQL Server Agent (MSSQLSERVER) service failed to start due to the following error:

    The service did not respond to the start or control request in a timely fashion. Think that is result of adding full access to user NT SERVICE\SQLSERVERAGENT in path data\MSSQL11.MSSQLSERVER\MSSQL\Binn

    Just confirmed User Rights Assignment > Log on as Service . The user SQL_agent_svc_usr does exist on the list.