Microsoft SQL Server Front End Blog

The writers of this blog are a part of the Microsoft SQL Server Manageability team. We will be blogging about our tools, scripts, webcasts, and miscellaneous tips that will help you get the most out of SQL Agent, Data collector and other tools

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

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

  • Comments 1

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

image

 

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.

image

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

image

 

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”

image

 

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

 

image

 

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

image  

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
http://www.microsoft.com/info/cpyright.htm

Leave a Comment
  • Please add 2 and 1 and type the answer here:
  • Post
  • 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

Page 1 of 1 (1 items)