The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
SQL Server 2005 SQL Agent XPs Disabled
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?
Asked:
2
2
1 Solution
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
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/
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
go
reconfigure
go
sP_Configure 'Agent XPs' ,1
GO
RECONFIGURE