March 3, 2013 at 3:33 pm
I just installed SQL Server Express with Advanced Services but can't manage to get SQL Server Agent service started...
Features Supported by the Editions of SQL Server 2012 seems to indicate that SQL Server Agent is not supported with the Express Edition
However, sql server agent seems installed...
Is there anyway to get it working?
I find slightly silly to install it with SQL Server Express if it's not meant to work??? :angry:
March 3, 2013 at 3:40 pm
SQL Server Express does not support SQL Agent.
By installed, do you mean the service is there?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 3, 2013 at 3:56 pm
I find slightly silly to install it with SQL Server Express if it's not meant to work??? :angry:
I seem to remember the reasoning behind this is to allow you to upgrade to other editions (such as Standard) without having to install additional files. (just enter the key for the upgraded edition).
could try this codeplex project as an alternative:
http://standalonesqlagent.codeplex.com/
Or create your own based on Service Broker (which I believe is available in Express edition).
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
March 4, 2013 at 1:50 am
Yes, everything is installed and looks all right but the service fails to start.
The error message seems about failing to access some registry entries.
March 4, 2013 at 1:53 am
ib.naji (3/3/2013)
I seem to remember the reasoning behind this is to allow you to upgrade to other editions (such as Standard) without having to install additional files. (just enter the key for the upgraded edition).could try this codeplex project as an alternative:
http://standalonesqlagent.codeplex.com/
Or create your own based on Service Broker (which I believe is available in Express edition).
It seems to make sense indeed.
Thanks for the codeplex alternative, I'll give that a shot.
Cheers
Eric
February 27, 2017 at 10:09 am
SQL Server Agent is not available for SQL Server Express Editions. There are alternatives available. I use:
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy