SQL 2014 ‘Agent XPs’ componet is turned off when accessing Maintenance Plans

When trying to create a Maintenance Plan you get an error: 

‘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. (Object Explorer)

Screenshot 2015 04 01 14 39 39

Details of the error are:

===================================

Cannot show requested dialog.

===================================

Unable to execute requested command.

——————————
Program Location:

at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolMenuItemHelper.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

===================================

‘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)

——————————
Program Location:

at Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.LoadData()
at Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm..ctor(XmlDocument doc, IServiceProvider serviceProvider)

 

The Cause

This is caused because the “SQL Server Agent” is not running.

By default, this service is set to start manually. This is normal after a fresh install.

 

The Solution

1. Open SQL Server Configuration Manager

2. Start the service for SQL Server Agent.

SQL Server Agent

3. Right click the service and select Properties

Screenshot 2015 04 01 14 43 29

4. Click the Service tab and change the start mode to Automatic

Screenshot 2015 04 01 14 43 48

That’s it! 

 

 

One Reply to “SQL 2014 ‘Agent XPs’ componet is turned off when accessing Maintenance Plans”

Leave a Reply