sqldbatips.com blog site Musings on SQL Server from Jasper Smith, SQL Server MVP SQL Server 2008 Express installs SQL Agent (but will not bother making an attempt to start out it) If you have installed either from the Express Editions on the market from the SQL Server 2008 RC0 download you could have noticed that as well as the SQL Server service for your Express instance, setup also installs the SQL Agent services. Superb news you may consider but no,
Microsoft Office 2007 Professional Plus, the service is set up inside a disabled state and will error should you try and start off it manually. This really is a modify in behaviour from SQL 2005 Express Edition which did not develop the SQL Agent service (or perhaps consist of sqlagent.exe) and is also far from ideal and may well be comfusing to consumers as confirmed by Microsoft in my Connect Bug for this difficulty then again in addition,
Windows 7 Product Key, it won't be fixed in SQL 2008.Why do I care (a) because I consider its confusing for prospects and (b) because I maintain the SQL 2005 Services Manager tool on Codeplex which despite its name does support SQL 2008 and this makes my life more difficult because I now have to check the instance editions and filter out SQL agent for 2008 Express instances (so for totally selfish reasons then,
Windows 7 64bit!). Along with the reappearance in the FTS service under a new name in RC0 it's making adding SQL 2008 compatability more painful than I had hoped :-)