Agent XPs Component is turned off

Leave a comment (1) Go to comments

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.

In Microsoft SQL Server Management Studio i get the following errors when trying to create a management plan either through the “Maintenance Plan Wizard” or the “New Maintenance Plan…” on an SQL Server 2008.

 

Agent XPs Component is turned off SQL Server maintenance plan error Error creating maintenance plan Agent XPs Component is turned off error

Agent XPs Component is turned off SQL Server maintenance plan error Error creating maintenance plan Agent XPs Component is turned off error

Actions Required to resolve this Error

To fix this click New Query button from the toolbar option, a query window will pop up on right side of the object explorer.

In the query window type the following:

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'Agent XPs', 1;

GO

RECONFIGURE

GO


Then click Execute or press (CTRL + E) after selecting the whole query.

Agent XPs Component is turned off SQL Server maintenance plan error Error creating maintenance plan Agent XPs Component is turned off error

As you can see in message box that it is saying

Configuration option ‘show advanced options’ changed from 1 to 1. Run the RECONFIGURE statement to install.

Configuration option ‘Agent XPs’ changed from 1 to 1. Run the RECONFIGURE statement to install.

This means on my machine ”show advanced & Agent XPs” is enabled, because its changed from 1 to 1. Remember the value 1 indicates ENABLE & 0 indicates DISABLE. So in my case the result is enable to enable as my services were enabled.

This will enable the Agent XPs & i hope you will not face this error next time. This solution worked for everyone till now.

EOF - Agent XPs Component is turned off, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

1 Comments.

  1. Worked perfectly! Thanks dude!!!

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.