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.
| 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 returnsSELECT SERVERPROPERTY('Edition')------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
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 |
|
|
|
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 expressAnyways glad that you got it sorted.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Error starting sql agent