Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Error starting sql agent

Author  Topic 

tracy5436
Yak Posting Veteran

50 Posts

Posted - 2013-10-31 : 22:00:34
Hi,

I have 2 versions of SQL Server running - 2012 and 2008 express. The sql agent for the 2012 instance is disabled and I am unable to start it. I have checked the registry for the path to the sqlagent.out file and it is in the correct location. The logon user is a member of the sysadmin role. When I check the error log, I get the message "This installation of SQL Server Agent is disabled. The edition of SQL Server that installed this service does not support SQL Server Agent".

I am receiving this error for the 2012 instance so it seems like something is wrong with the agents for both instances. I ran a repair and this did not fix the problem.

How can I fix this ?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-11-01 : 13:33:25
whats the edition you're using?
Try this and see what it returns


SELECT SERVERPROPERTY('Edition')


------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

tracy5436
Yak Posting Veteran

50 Posts

Posted - 2013-11-03 : 17:41:36
This query returned SQL Express even thought SQL Standard was installed. I ran the edition upgrade and its ok now.

Thanks
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-11-04 : 00:31:22
quote:
Originally posted by tracy5436

This query returned SQL Express even thought SQL Standard was installed. I ran the edition upgrade and its ok now.

Thanks


Nope..if it says sql express then it was express edition.
May be you were using desktop (client) tools of standard edition whereas you actual db instance was express
Anyways glad that you got it sorted.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -