Aleks
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-26931 d2012f4}" EventSourceName="Service Control Manager" />
<EventID Qualifiers="49152">7034</E ventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80800000000000 00</Keywor ds>
<TimeCreated SystemTime="2012-09-16T20: 49:31.4110 33500Z" />
<EventRecordID>140431</Eve ntRecordID >
<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>
- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
<Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-
<EventID Qualifiers="49152">7034</E
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80800000000000
<TimeCreated SystemTime="2012-09-16T20:
<EventRecordID>140431</Eve
<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>
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
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/2 012/07/06/ how-to-kno w-the-serv er-details -of-your-s erver/
if you are using SQL Server Express edition it is not possible to start
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/2
if you are using SQL Server Express edition it is not possible to start
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.
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)
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.
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.
"select @@version"
It should return a single line, which you should be able to copy and paste into the comment window.
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
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
Take the quotes out of the query, and run the query again. (my fault.)
select @@version
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
sql-error.gif