September 5, 2009 at 12:16 am
Hello Team,
I have sql server express edition installed. My sql server agent is not running. When I start this then it throws error as follows:
"This service started and then stopped. Some services stop automatically when they are not in use by other services or programs."
I can see that in the logon tab this service is running under 'Local System Account'.
-LK
September 5, 2009 at 12:40 am
As far as i know, sql agent services are not a part of express edition.
September 5, 2009 at 1:43 am
That's right - Express does not include the SQL Job Agent.
Might the installed service belong to some other installed instance of some other edition of SQL Server?
Has the machine in question ever had a prior version (say 2000) installed?
Do you try to upgrade it to Express or something?
Without more details, it's hard to guess.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
September 5, 2009 at 3:45 am
Oh I found. When sql server express edition is installed then sql server agent service is installed but this never runs. Dumb service is installed by Microsoft.
-LK
September 5, 2009 at 6:04 am
luckysql.kinda (9/5/2009)
Oh I found. When sql server express edition is installed then sql server agent service is installed but this never runs. Dumb service is installed by Microsoft.-LK
I might have helped if:
a) You had mentioned that it was 2008 Express; and
b) If you had posted the question in the 2008 forums rather than 2005...
This situation is unfortunate - Microsoft apparently plan to fix this 'after RTM' 😀
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=351806&wa=wsignin1.0
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply