Unable to start sql server agent

When trying to start it in the sql server configuration Manager. I supply the Built in account as Local Server, Local Service & get a error.
The Service cannot be started, either because it is diabled or because it has no enabled devices associated to it. [0x80070422]
SQL Server 2008 Developer Edition
u2envy1Asked:
Who is Participating?
 
reb73Commented:
The Express edition does not have SQL Server Agent feature at all.

Check the link below to get an idea of the feature breakdown by edition  -

http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx
0
 
reb73Commented:
Can you check if Agent XPs are enabled in SQL Server Surface Area Management tool? If not enable it there..

You can also check and enable it in query window as follows -

use master
exec sp_configure 'show advanced options','1'
RECONFIGURE
go

exec sp_configure 'Agent XPs','1'
RECONFIGURE
go
0
 
u2envy1Author Commented:
I dont have Surface Area Management tool. Is it because of my Express Advanced Edition of SQL ?
0
 
u2envy1Author Commented:
Thx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.