Click here to Skip to main content
15,799,017 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Is there alternatives for Microsoft SQL Server Agent in creating a JOBS?

Im Using Microsoft SQL Server Management Studio 2008 R2,
and the Server agent
whenever I start, On in services, it failed and stop immediately,
I change the value of this to 1 in registry and I still didn't fix the Problem...
Is there alternatives with this?

Tnx! :)
Posted
Comments
Kornfeld Eliyahu Peter 19-Jan-14 5:16am    
To be clear - you have problems to start Agent?
Can you look into Event Log and see why it's failed?
Member 10533469 19-Jan-14 8:27am    
1. When i change the registry value from BLANK to 1.
-Server resumed execution after being idle 49 seconds: user activity awakened the server. This is an informational message only. No user action is required.

2.
-SQLServerAgent could not be started (reason: Unable to connect to server '1'; SQLServerAgent cannot start).

SQLServerAgent could not be started (reason: This installation of SQL Server Agent is disabled. The edition of SQL Server that installed this service does not support SQL Server Agent.).

I read some article that sql r2, is not supported by sql server agent
Now I know why,
Member 10533469 19-Jan-14 8:30am    
SQLServerAgent could not be started (reason: This installation of SQL Server Agent is disabled. The edition of SQL Server that installed this service does not support SQL Server Agent.).

-Is there any solution for this?
-Im planning to install the Microsoft® SQL Server® 2008 Enterprise Evaluation: Trial Experience for IT Professionals.

any advice, should i go for this?
Kornfeld Eliyahu Peter 19-Jan-14 8:51am    
I do not know what registry value you changed but according to the response in the error it should be the name of the SQL server instance - so do not change it.
Not all editions of SQL supports Agent - check your edition.
If you just upgraded your edition you may check here: http://support.microsoft.com/kb/955763
Member 10533469 19-Jan-14 9:35am    
my version is Microsoft SQL server 2008 management studio express
SQL Server 10.50.4000

1 solution

Not all SQL editions supporting Agent.
Please check your edition's features here http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx[^].
If you have access to other edition (that does support Agent), you can install it. For side-y-side installations read here http://technet.microsoft.com/en-us/library/ms143694(v=sql.105).aspx[^].
 
Share this answer
 
Comments
Meenakshi Moolani 17-May-16 8:07am    
Sql server agent could not be started
Reason from event log
The installation of sql server agent is disable the edition of sql server that installed does not support sql server agent
Can you solve this issue

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900