I have noticed that SQL Agent does not start automatically after a reboot/shutdown on a few of our servers (SQL server starts up fine). The service is set to automatically start in windows. When we start SQL agent manually, it starts fine.
This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown.
This issue happens because the SQL Server lost the logon id credentials or used an account without rights to start services. For starting your services automatically, SQL Server needs an account with rights to start services during operating system start up.
You should set it to automatic if you intend to use it. I am not sure why Microsoft decides to leave the default to manual after installation but I always change it because I always schedule maintenance. So you are on the right track to start and set to automatic.
Add your windows level user in following path:
Click on Start - Run - Secpol.msc
Go to: Local Policies - User right assignments
Ensure the user account your running the SQL Agent Service under has the following assignments:
Act as a part of the Operating system
bypass Traverse checking
Lock pages in memory
Log on as a service
Log on a batch job
Replace process level token
If not, please add them and try restarting your system. Your SQL Server should be now be automatically starting as a service.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With