Bob
asked on
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?
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
go
reconfigure
go
sP_Configure 'Agent XPs' ,1
GO
RECONFIGURE