Unable to start sql server agent

Posted on 2009-04-17
Last Modified: 2012-05-06
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
Question by:u2envy1
    LVL 25

    Expert Comment

    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'

    exec sp_configure 'Agent XPs','1'

    Author Comment

    I dont have Surface Area Management tool. Is it because of my Express Advanced Edition of SQL ?
    LVL 25

    Accepted Solution

    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  -

    Author Closing Comment


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now