SQL server agent 2008 R2 not starting

I have tried pretty much everything to get my sql server agent to start but simply won't. here is the log:

- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
  <Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-8e1e-26931d2012f4}" EventSourceName="Service Control Manager" />
  <EventID Qualifiers="49152">7034</EventID>
  <TimeCreated SystemTime="2012-09-16T20:49:31.411033500Z" />
  <Correlation />
  <Execution ProcessID="552" ThreadID="7068" />
  <Security />
- <EventData>
  <Data Name="param1">SQL Server Agent (BLUEDOT)</Data>
  <Data Name="param2">5</Data>
Who is Participating?
Rich WeisslerConnect With a Mentor Professional Troublemaker^h^h^h^h^hshooterCommented:
There you go then... you have Express Edition.  As the first experts expressed, it can never run Agent.
AleksAuthor Commented:
Here is a screenshot when trying to start the service.
Nico BontenbalCommented:
Are you using SQL Server Express. SQL Agent doesn't work on Express. Also this article has some suggestions:
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Ramesh Babu VavillaCommented:
how do you start your SQLserver services,using service accounts  or local system,
try to start SQL Server Agent service from SQL Server configuration Manager.

which edition of SQL Server do you use, to check which edition u are using check this blog

if you are using SQL Server Express edition  it is not possible to start
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
As folks have already mentioned, the Agent gets installed in Express Edition, and can never be started.

Looking at the screen shot, it doesn't LOOK like Express.  On the assumption it isn't:
  Confirm that this isn't a failover cluster, and you aren't attempting to start the agent on the non-active node.
  Check the account used by the agent, make certain it has the correct permissions.

Has this Agent ever worked, or is this a new install?

Are there any other warnings/errors in the Windows Application or System logs?

Is the MSDB on this instance of SQL healthy and readable?

Check in the agent log file (often ../MSSQL/Log/SQLAGENT.OUT) to see if the agent managed to write anything before stopping.
AleksAuthor Commented:
The log says it actually starts, then stops. I have had this install for a while just never used the agent until now, so its hard to say if it was ever running.
I do not think this is express.  It is developers edition 2008 RC2

I can open enterprise manager and open any database just fine.
Ill check the log and get back to you.
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
from the SQL Management Studio, run a query:
"select @@version"

It should return a single line, which you should be able to copy and paste into the comment window.
AleksAuthor Commented:
I got an error:  Could not find stored procedure 'select @@version'

In the 'about' section this is what it says:


Microsoft SQL Server Management Studio                                    10.50.2500.0
Microsoft Data Access Components (MDAC)                                    6.1.7601.17514
Microsoft MSXML                                    3.0 4.0 5.0 6.0
Microsoft Internet Explorer                                    9.0.8112.16421
Microsoft .NET Framework                                    2.0.50727.5456
Operating System                                    6.1.7601
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
The about section tells you about the Management Studio program itself, not the server, unfortunately.  10.50.2500 is SQL 2008 R2, SP1 -- so the management studio is good.

Take the quotes out of the query, and run the query again.  (my fault.)
select @@version
AleksAuthor Commented:
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (Intel X86)   Jun 17 2011 00:57:23   Copyright (c) Microsoft Corporation  Express Edition with Advanced Services on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (WOW64)
AleksAuthor Commented:
ugh  :(  ... thats terrible ... ill have to do it manually then ... thx
Nico BontenbalCommented:
You might be able to write some scripts (powershell or VB script for example) and schedule those with Scheduled Tasks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.