August 6, 2013 at 5:25 am
Hi,
I'd heard that if i installed this new SSMS tool on an instance that had Express already installed on it I'd get SSMS which included the Agent etc. So I installed fine and there is an Agent service which started ok. However there is no SQL Agent under SSMS? Can anyone confirm one way or another if there is any Express option that comes with the SQL Agent. If not why does it install with the SQL Agent service?
Thank-you
August 7, 2013 at 2:28 am
There is no Express edition of SQL server that comes with a working SQL Agent, no--if you actually try to start the Agent service you'll find it stops almost immediately. This is one of the ways Microsoft ensures there's clear blue water between the freebie edition and the version that costs several thousand! As for why it installs the Agent service in the first place, one assumes there's a dependency between the services that isn't easy for Microsoft to remove, so they install a hobbled service that won't ever start but which fulfils the dependency.
August 7, 2013 at 2:33 am
ok thanks for that Paul. I guess i'll need to set up some jobs on a separate server but run them against this one. Thanks again.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply