When SQL Server 2005 Management Studio’s Object Browser shows the SQL Server Agent service

with a red down arrow and the text Agent XP’s disabled, the service is not started or

disabled.

Start the SQL Server Agent service by:

  • using the SQL Server Configuration Manger
    located in Start -> Microsoft SQL

    Server 2005 -> Configuration Tools -> SQL Server Configuration Manager

  • Or use the Services Management Console
    located in Start -> Control Panel ->

    Administrative Tools -> Services

  • Or you can start the default service from the command prompt
    net start “SQL Server

    Agent (instance name)”
    Eg: net start “SQL Server Agent (MSSQLSERVER)”

Tags: Management Studio, SQL Server, Tools