SQL Server Home
SQL Express RC0 installs SQL Agent Service for no apparent reason
as Won't Fix
6/18/2008 1:37:43 PM
User(s) can reproduce this bug
When you install RC0 and select Express from the available editions, setup installs SQL Agent as well as the SQL Service (although it is set to disabled). This seems pointless as it cannot be started and is a change in behaviour from SQL 2005. I'm sure this is "By Design" howerver it seems part of a trend of SQL Setup installing unnescessary and unwanted components (like clustered instances installing FTS + Replication) whilst removing the choice and control from the customer. I'm also sure that everyone will at least once try starting the SQL Agent associated with the Express instance regardless of the documentation stating that it is not supported. It is also not beyond the realms of possibility to imagine CSS cases from customers complaining that the SQL agent service won't start and it turning out to be an express instance :-)
SQL Server 2008 Release Candidate 0
Win2003 Enterprise Server (SP2)
Operating System Language
Steps to Reproduce
Install SQL 2008 RC0 and select SQL Express on the Edition selection page
A disabled and useless SQL Agent service is created for the Express instance
No SQL Agent service is created for an Express instance
to post a comment.
Please enter a comment.
on 10/26/2012 at 11:43 AM
After 6 mos. of struggling to build a dev. environment, downloading dozens of patches and add-ons, pouring thru MSDN and Google at nearly every turn for help and resolutions, we finally got an instance up and running so we could learn SharePoint - or so we thought. Now we find that SQL Server Agent won't run and we cannot use SSMA to import all our MySQL data into SQL because we choose to set up a learnng environment using Express!! I guess we should have spent thousands of $ and installed Enterprise but even this expense would probably not have guaranteed a successful build. Our conclusion: $harePoint is a hapless monster!
Micro$oft, ya better get it right! Meanwhile, we are looking into Adobe's CQ5.
on 1/18/2012 at 11:39 AM
It is not long after RTM and this "by desing" feature persists. I wonder what Microsoft means by "working diligently" and when they might execute their plan to address this, or at least let us know what the plan is. It has been three and a half years now - how long does it take to not install software that cannot be run?
on 10/13/2011 at 5:59 AM
I'm confused by the Microsoft reply. I just downloaded SQL Server 2008 R2 Express Edition for a 32-bit system, and yes the agent is in Stopped state. The comment is to the effect that the product shipped but cannot be used? What am I supposed to do now? It's 3 years later.
on 8/23/2010 at 6:53 PM
By design? Highly unlikely. It's more than two years later, and this ridiculous behavior has not changed. What on earth is the point in forcing people to download and install a product that you expressly prohibit them from running? In what possible world was that considered a good idea?
on 2/12/2009 at 1:49 PM
This should be fixed - it wasted my precious time too.
on 6/18/2008 at 3:16 PM
You are right, it is by design, but it is clearly not a desired state. However, unfortunately we will be shipping this way for SQL Server 2008. This is a combination of engineering decisions and business decisions not happening at the same time and not having clear communication.
We are working diligently to improve this communication and plan to address this after RTM.
to post a workaround.
Please enter a workaround.
© 2014 Microsoft