Home Library Learn Downloads Support Community
Sign in | United States - English | |
4 out of 12 rated this helpful - Rate this topic

How to: Start SQL Server Agent (SQL Server Configuration Manager)

SQL Server 2008 R2

SQL Server Agent can be stopped and started from SQL Server Configuration Manager.

To start the SQL Server Agent service

  1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.

  2. In SQL Server Configuration Manager, expand Services, and then click SQL Agent.

  3. In the results pane, right-click any instance, and then click Start.

    A green arrow on the icon next to the SQL Server Agent and on the toolbar indicates that SQL Server Agent started successfully.

  4. Click OK.

For information about how to run SQL Server Agent in verbose mode for troubleshooting, see sqlagent90 Application.

Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
Cannot start Server agent in SQL 2008R2 developer version
I am using SQL Server 2008R2 Developer version (for students) and I could not start the Server agent either from services or from configuration manager. Any suggestion to make it work would be appreciated.   $0Thanks $0
History
Server Agent is Installed, but Disabled in Expression Edition
Don't waste your time trying to get this working if you have the express edition. It won't. Tested with version 10.20.1600.1 and verified here:

https://connect.microsoft.com/SQLServer/feedback/details/351806/sql-express-rc0-installs-sql-agent-service-for-no-apparent-reason
History
Greyed Out
On my instance, this option is greyed out. Is it because I am running SQL Express? (2008 R2) If not, what do I need to do to make this option not greyed out.

Added 2/11/2011: Set the service from Disabled to Automatic in services.msc. Attempting to change the Start Mode to Automatic under SQL Server Configuration Manager caused the SQL Server Agent Properties dialog box to stop responding, but after logging out and back in, the start mode for SQL Server Agent was Automatic and I was able to right click and choose start. Log ON is set to Build-in account: Network Service. Result: Starting service ... "The request failed or the service did not respond in a timely fashion. Consult the event log...". Event log: Event ID 103. "SQLServerAgent could not be started (reason: Error creating a new session).". In SQL Server Management Stuido | Security | Logins, adding NT AUTHORITY\NETWORK SERVICE and granting sysadmin permission didn't help. SQL server service itself is running as LocalSystem, but attempting to change SQL Server Agent to Log On As LocalSystem produces an error "This request is not supported." from within SQL Server Config Mgr. In services.msc, changing Log On As to LocalSystem for SQL Server Agent works, but the service still won't start. Now the error in Event Viewer is "SQLServerAgent could not be started (reason: This installation of SQL Server Agent is disabled. The edition of SQL Server that installed this service does not support SQL Server Agent.)."





History