[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2352
  • Last Modified:

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>
0
Aleks
Asked:
Aleks
  • 5
  • 4
  • 2
  • +1
1 Solution
 
AleksAuthor Commented:
Here is a screenshot when trying to start the service.
sql-error.gif
0
 
Nico BontenbalCommented:
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
0
 
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
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
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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.
0
 
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.
0
 
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.
0
 
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
0
 
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
0
 
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)
0
 
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
Wondermus!
There you go then... you have Express Edition.  As the first experts expressed, it can never run Agent.
0
 
AleksAuthor Commented:
ugh  :(  ... thats terrible ... ill have to do it manually then ... thx
0
 
Nico BontenbalCommented:
You might be able to write some scripts (powershell or VB script for example) and schedule those with Scheduled Tasks.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 5
  • 4
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now