Solved

SQL Server 2005 SQL Agent XPs Disabled

Posted on 2009-07-02
4
519 Views
Last Modified: 2012-05-07
My SQL Agent is stuck in a "Agent XPs Disabled" mode and cannot get it out. I've attempted to stop and restart the service in the SQL Configuration Manager, but it's still showing the same error. Can some help me to get this back in working order?
0
Comment
Question by:Robert Pollick
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24769909
sp_configure 'show advanced options', 1
go
reconfigure
go
sP_Configure 'Agent XPs' ,1
GO
RECONFIGURE
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24769913
0
 
LVL 21

Expert Comment

by:Tapan Pattanaik
ID: 24770041
hi rpollick,

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)"

http://www.julian-kuiters.id.au/article.php/sql2005-agent-xps-disabled
0
 
LVL 21

Accepted Solution

by:
Tapan Pattanaik earned 500 total points
ID: 24770059
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

710 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