SQL Server Performance

SQL Server Agent doesn't start automatically after reboot

Discussion in 'SQL Server 2008 General DBA Questions' started by apat, Apr 4, 2011.

  1. apat New Member

    Hello,I restarted my machine yesterday and sql agent didn't start eventhough it is set to start automatically. It runs under windows authentication.Error in Windows Application log says:Login failed for user 'NT AUTHORITYSYSTEM'. Reason: Failed to open the explicitly specified database.SQLServerAgent could not be started (reason: Unable to connect to server 'BATCHSERVERPRD'; SQLServerAgent cannot start). Default database for 'NT AUTHORITYSYSTEM' login is master database.Can anyone please help?
  2. satya Moderator

    Is there any specific reason why you are starting SQLAgent account with default logins, rather use a local login on server to restart services with proper privileges.
    See this KBA http://support.microsoft.com/kb/2160720 for more information on best practices.

Share This Page