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.
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.
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.