Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks
Solved
SQL Server 2005 SQL Agent XPs Disabled
Posted on 2009-07-02
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?
[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
sp_configure 'show advanced options', 1
go
reconfigure
go
sP_Configure 'Agent XPs' ,1
GO
RECONFIGURE
go
reconfigure
go
sP_Configure 'Agent XPs' ,1
GO
RECONFIGURE
Active today
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
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
Active today
Agent XPs disabled:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_22665316.html
Agent XPs Option:
http://msdn.microsoft.com/en-us/library/ms178127.aspx
http://www.julian-kuiters.id.au/article.php/sql2005-agent-xps-disabled
How to resolve : Agent XPs disabled:
http://sharepoint4u.wordpress.com/2009/01/15/how-to-resolve-agent-xps-disabled/
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_22665316.html
Agent XPs Option:
http://msdn.microsoft.com/en-us/library/ms178127.aspx
http://www.julian-kuiters.id.au/article.php/sql2005-agent-xps-disabled
How to resolve : Agent XPs disabled:
http://sharepoint4u.wordpress.com/2009/01/15/how-to-resolve-agent-xps-disabled/
Featured Post
![[eBook] Windows Nano Server](https://filedb.experts-exchange.com/files/public/2017/6/24/1329f749-2f43-4bd1-8413-3b5b5ab33fc6.png)
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction
This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses
Course of the Month5 days, 13 hours left to enroll
688 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.