SQLSERVER Agent is not running- SQLSERVER 2008R2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQLSERVER Agent is not running- SQLSERVER...

SQLSERVER Agent is not running- SQLSERVER 2008R2

Rate Topic

Display Mode

Topic Options

Author

Message

sram24_mca

Posted Tuesday, July 17, 2012 3:00 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:14 AM
Points: 85, Visits: 342

Hello:
We have Windows 7 with SQLSERVER 2008R2 Express Edition 10.5 Installed. Database Engine and SQL Browser services are running perfect .The Problem is SQLSERVER Agent is not running. We have Provided the all the permissions to logged in users. Can anyone help us to resolve the problem?

Thanks in advance ..!

Regards,
Ram

Post #1330585

sqlzealot-81

Posted Tuesday, July 17, 2012 3:08 AM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 12:14 AM
Points: 730, Visits: 1,740

Service has been started? Whats the error in error log? anything in the application eventviewer?

Post #1330589

deepaks 80520

Posted Tuesday, July 17, 2012 4:36 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, August 02, 2012 10:25 PM
Points: 29, Visits: 19

Check whether SQLAgent Service is set to Automatic startup mode.

Post #1330636

anthony.green

Posted Tuesday, July 17, 2012 4:42 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:40 AM
Points: 5,075, Visits: 4,833

Express doesnt come with an agent.

Granted it looks like an agent is installed in services.msc but this is a bug with the install in 2008 and as such the agent is none usable for express instances.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1330640

sram24_mca

Posted Tuesday, July 17, 2012 5:32 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:14 AM
Points: 85, Visits: 342

Thanks

Is there any workaround to make the agent to run?

The Error Message is :
[color=#3282]
The service cannot be started, either because it is disabled or because it has no enabled devices associated with
[/color]

Regards,
Ram

Post #1330657

anthony.green

Posted Tuesday, July 17, 2012 5:39 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:40 AM
Points: 5,075, Visits: 4,833

No, there is no agent with SQL express.

If you want a SQL agent you will need a higher product, like Standard or Enterprise.

If you need to schedule tasks in express you need to use a 3rd party task scheduler or the built in task scheduler in Windows.

Post #1330658

deepaks 80520

Posted Tuesday, July 17, 2012 5:46 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, August 02, 2012 10:25 PM
Points: 29, Visits: 19

Yes you are right. I didn't notice Express edition in the question.

Post #1330665

« Prev Topic | Next Topic »

Permissions