Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
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
Active 6 days ago
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
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted? Many believe this is the case.
Let us try to examine for ourselves with an example.
To get started, use the following script, wh…
In this article I will describe the Backup & Restore 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.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…
- Microsoft Applications
- Windows 10
- Windows OS
- Fonts Typography
- Windows 7, Microsoft Word
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month5 days, 2 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
636 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.