Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Express and SQL Server Agent? Expand / Collapse
Author
Message
Posted Sunday, March 3, 2013 3:33 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 3:05 PM
Points: 1,191, Visits: 791
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???
Post #1426025
Posted Sunday, March 3, 2013 3:40 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:43 PM
Points: 43,047, Visits: 36,206
SQL Server Express does not support SQL Agent.

By installed, do you mean the service is there?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1426026
Posted Sunday, March 3, 2013 3:56 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, September 8, 2014 1:14 PM
Points: 91, Visits: 164,592
I find slightly silly to install it with SQL Server Express if it's not meant to work???


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.

I believe in Codd
... and Thinknook is my Chamber of Understanding
Post #1426032
Posted Monday, March 4, 2013 1:50 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 3:05 PM
Points: 1,191, Visits: 791
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.
Post #1426124
Posted Monday, March 4, 2013 1:53 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 3:05 PM
Points: 1,191, Visits: 791
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
Post #1426125
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse