July 17, 2012 at 3:00 am
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
July 17, 2012 at 3:08 am
Service has been started? Whats the error in error log? anything in the application eventviewer?
July 17, 2012 at 4:36 am
Check whether SQLAgent Service is set to Automatic startup mode.
July 17, 2012 at 4:42 am
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.
July 17, 2012 at 5:32 am
Thanks
Is there any workaround to make the agent to run?
The Error Message is :
The service cannot be started, either because it is disabled or because it has no enabled devices associated with
Regards,
Ram
July 17, 2012 at 5:39 am
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.
July 17, 2012 at 5:46 am
Yes you are right. I didn't notice Express edition in the question.
July 12, 2013 at 1:22 am
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.
July 12, 2013 at 4:07 am
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"
July 15, 2013 at 12:58 am
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
July 15, 2013 at 1:09 am
I mean, could not be run if the Replication Agent function does not work, being in the Replication tables that can be run even if only "Subscriber only", among others, Snapshot replication, Merge replication, Transactional replication...
July 15, 2013 at 1:10 am
I mean, could not be run if the Replication Agent function does not work, being in the Replication tables that can be run even if only "Subscriber only", among others, Snapshot replication, Merge replication, Transactional replication...
http://technet.microsoft.com/en-us/library/cc645993(v=sql.105).aspx
July 15, 2013 at 1:56 am
For replication there written "Subscriber only", instead of requiring replication Agent
You can search by key word Replication
Different agent. The original post is about the SQL Server Agent, not agents dealing with replication (merge, distribution, push/pull, etc.).
Joie Andrew
"Since 1982"
July 16, 2013 at 6:18 pm
Correct & I understand about it, I just showed that reference tables issued by the official website of Microsoft also make the user misguided, because my assumption that it could run the replication list then automatically SQL Server Agent must also Enable or can be run. I mean it, and thank you very much.
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply