Question:

I was wanting to create a SQL 2005 Maintenance task and get this error. How can I enable the Maintenance task wizard ?

ITLE: Microsoft SQL Server Management Studio
——————————
Cannot show requested dialog.
——————————
ADDITIONAL INFORMATION:

Unable to execute requested command.
——————————
‘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. (Microsoft.SqlServer.Management.MaintenancePlanWizard)

——————————
BUTTONS:

OK
——————————

Solution:

http://naspinski.net/post/Agent-XPs-component-is-turned-off-as-part-of-the-security-configuration-for-this-server.aspx

This should help you to fix this.