Start SQL Server Agent service, set service startup mode using SQL Server Configuration Manager

Here are the steps  to Start SQL Server Agent service using SQL Server Configuration Manager. Using SQL Server Configuration Manager, you can also set Agent Service startup parameters like changing service startup account


1) Launch SQL Server Configuration Manager

In Windows desktop, click on Start –> All Programs –> Microsoft SQL Server 2008 R2 –> SQL Server  Configuration Manager



2) View SQL Agent Service properties

On left pane, click on “SQL Server Services”; on right pane, you will see all installed instances of SQL Sever components.


To View SQL Server Agent properties, double click on SQL Server Agent ( MSSQLSERVER) entry on left pane. You will see a property dialog



3) Set SQL Agent Service start up mode = “Automatic”.

By setting service startup mode to “Automatic” SQL Agent service is started up when machine starts up. Select “Automatic” from drop down next to Startup Mode setting; click  “Ok”



4) Start SQL Agent Service

Select “SQL Server Agent Service ( MSSQLSERVER )” entry on right pane. Right click on right pane in SQL Server configuration Manager; click on “Start” menu




5) Verify SQL Server Agent service is running

Click on menu Action –> Refresh; On right pane, check SQL Server Agent's service state as "Running".


This posting is provided "AS IS" with no warranties, and confers no rights. 
Use of included script samples are subject to the terms specified at

Comments (1)

  1. Duong Chi Tam says:

    I have done so that, but when go to "4) Start SQL Agent Service". It still can't successful. Please help me other way. Thank

Skip to main content