Skip to content

Agent XPs Error SQL Server 2012

by on March 25, 2014

Error:

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)

 

No SQL Solution:

Sql Server Configuration Manager > SQL Server Services

In the right pane > right click on SQL Server Agent > click start

It should now say running nest to the service

image

SQL Query Solution:

 

sp_configure ‘show advanced options’, 1;

GO

RECONFIGURE;

GO

sp_configure ‘Agent XPs’, 1;

GO

RECONFIGURE

GO

Advertisements
Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: