SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Error starting sql agent
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tracy5436
Yak Posting Veteran

50 Posts

Posted - 10/31/2013 :  22:00:34  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 11/01/2013 :  13:33:25  Show Profile  Reply with Quote
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 - 11/03/2013 :  17:41:36  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 11/04/2013 :  00:31:22  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000