Fix – Agent XPs’ component is turned off as part of the security configuration for this server

If you get this message when try to edit a maintenance task:

‘Agent XPs’ component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Agent XPs’ by using sp_configure. For more information about enabling ‘Agent XPs’, see “Surface Area Configuration” in SQL Server Books Online. (ObjectExplorer)

Chances are your MS SQL Agent isn’t running. Just start the service and you should be good. I would recommend going into servers and setup a recovery option to restart upon failure, this will keep a watch over it and start it if its stopped.

How To Disable Windows 2008 Firewall Without RDP Disconnecting

If you turn off the windowd firewall through services it will stop all connections and you will lose your RDP connection. Not good if your working on a server remotely.

If you need to turn off the firewall you may do this in Windows Firewall with Advanced Security (wf.msc) by setting the state to Off for all three profiles (or only certain profiles), or via administrator command prompt:

netsh advfirewall set allprofiles state off

Reference:

http://social.technet.microsoft.com/Forums/en-US/winserverTS/thread/19486b87-9b68-4d18-9047-b35dab89ff7b