Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQLSERVER Agent is not running- SQLSERVER 2008R2 Expand / Collapse
Author
Message
Posted Tuesday, July 17, 2012 3:00 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 10:49 PM
Points: 90, Visits: 388

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
Posted Tuesday, July 17, 2012 3:08 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 6:02 AM
Points: 731, Visits: 2,025
Service has been started? Whats the error in error log? anything in the application eventviewer?
Post #1330589
Posted Tuesday, July 17, 2012 4:36 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, August 7, 2013 6:53 PM
Points: 91, Visits: 24
Check whether SQLAgent Service is set to Automatic startup mode.
Post #1330636
Posted Tuesday, July 17, 2012 4:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:49 AM
Points: 5,216, Visits: 5,110
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
Posted Tuesday, July 17, 2012 5:32 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 10:49 PM
Points: 90, Visits: 388
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
Posted Tuesday, July 17, 2012 5:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:49 AM
Points: 5,216, Visits: 5,110
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.




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 #1330658
Posted Tuesday, July 17, 2012 5:46 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, August 7, 2013 6:53 PM
Points: 91, Visits: 24
Yes you are right. I didn't notice Express edition in the question.
Post #1330665
Posted Friday, July 12, 2013 1:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 6:49 PM
Points: 5, Visits: 12
I have same problems, visit this link;
http://technet.microsoft.com/en-us/library/cc645993(v=sql.105).aspx
There is written that SQL 2008 R2 Express support for Replication "Subscription only"? but can not be used.

Post #1472879
Posted Friday, July 12, 2013 4:07 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 6:11 AM
Points: 709, Visits: 1,423
I have same problems, visit this link;
http://technet.microsoft.com/en-us/library/cc645993(v=sql.105).aspx
There is written that SQL 2008 R2 Express support for Replication "Subscription only"? but can not be used.


Is this reply to the correct forum post? The OP did not mention anything about replication. Regardless the link does still highlight the fact that none of the express editions have the agent.


Joie Andrew
"Since 1982"
Post #1472926
Posted Monday, July 15, 2013 12:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 6:49 PM
Points: 5, Visits: 12
Thank you, for your response, Joie Andrew

For replication there written "Subscriber only", instead of requiring replication Agent
You can search by key word Replication
Post #1473481
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse