SQL Express RC0 installs SQL Agent Service for no apparent reason - by sqldbatips

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 351806 Comments
Status Closed Workarounds
Type Bug Repros 9
Opened 6/18/2008 1:37:43 PM
Access Restriction Public


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 :-)
Sign in to post a comment.
Posted by Snagged 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.
Posted by sahack1 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?
Posted by Frank Fallon 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.
Posted by Bill Mercer 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?

Posted by 10e on 2/12/2009 at 1:49 PM
This should be fixed - it wasted my precious time too.
Posted by Microsoft 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.

-Richard Waymire