I can not start Sql Server agent to create job. Can anyone help me? . I'm using Windows 7 Ultimate , Sql server 2008 Rc2

See this images:

enter image description here

enter image description here


2 Answers 2


SQL Server Express Edition does not include SQL Agent functionality.

While the installer does register the service entry, the service will fail to start if you try. (I verified with one of my own instances -- the error message I got is exactly the same.)

See this MSDN article for a comparison of features available in each edition of SQL Server 2008 R2.

If it's appropriate for what you need to accomplish, you can use the Windows Task Scheduler instead.


If you upgraded your SQL Server instance from SQL Server Express, this link might explain and solve your problem:


"The SQL Server Agent service does not start after you upgrade from SQL Server 2008 Express or from SQL Server 2008 Express with Advanced Services to SQL Server 2008 Developer, to SQL Server 2008 Enterprise, or to SQL Server 2008 Standard"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.