Link to home
Start Free TrialLog in
Avatar of Aleks
AleksFlag for United States of America

asked on

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>
  <Version>0</Version>
  <Level>2</Level>
  <Task>0</Task>
  <Opcode>0</Opcode>
  <Keywords>0x8080000000000000</Keywords>
  <TimeCreated SystemTime="2012-09-16T20:49:31.411033500Z" />
  <EventRecordID>140431</EventRecordID>
  <Correlation />
  <Execution ProcessID="552" ThreadID="7068" />
  <Channel>System</Channel>
  <Computer>AK-PC</Computer>
  <Security />
  </System>
- <EventData>
  <Data Name="param1">SQL Server Agent (BLUEDOT)</Data>
  <Data Name="param2">5</Data>
  </EventData>
  </Event>
Avatar of Aleks
Aleks
Flag of United States of America image

ASKER

Here is a screenshot when trying to start the service.
sql-error.gif
Avatar of Nico Bontenbal
Are you using SQL Server Express. SQL Agent doesn't work on Express. Also this article has some suggestions:
http://codespin.blogspot.nl/2008/01/fixing-startup-failure-of-sql-server.html
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
http://sqlservr.blog.com/2012/07/06/how-to-know-the-server-details-of-your-server/


if you are using SQL Server Express edition  it is not possible to start
Avatar of Rich Weissler
Rich Weissler

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.
Avatar of Aleks

ASKER

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.
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.
Avatar of Aleks

ASKER

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
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
Avatar of Aleks

ASKER

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)
ASKER CERTIFIED SOLUTION
Avatar of Rich Weissler
Rich Weissler

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Aleks

ASKER

ugh  :(  ... thats terrible ... ill have to do it manually then ... thx
You might be able to write some scripts (powershell or VB script for example) and schedule those with Scheduled Tasks.