SQL Server Agent not starting automatically on server reboot

sql sql-server sql-server-2008 windows-server-2008 sql-agent-job
LomA picture LomA · Sep 2, 2014 · Viewed 13.6k times · Source

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.

Answer

Mayuresh Jadhav picture Mayuresh Jadhav · Sep 9, 2014

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:

  1. Act as a part of the Operating system

  2. bypass Traverse checking

  3. Lock pages in memory

  4. Log on as a service

  5. Log on a batch job

  6. 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.

Related questions

How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More
How to Delete using INNER JOIN with SQL Server?

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line 15 Incorrect syntax near the keyword 'INNER'. My code: DELETE FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' …

Read More
Rename column SQL Server 2008

I am using SQL Server 2008 and Navicat. I need to rename a column in a table using SQL. ALTER TABLE table_name RENAME COLUMN old_name to new_name; This statement doesn't work.

Read More