Fix for Agent XPs’ component is turned off as part of the security configuration for this server

Today, I was working on preparing a series of demonstration scripts for an upcoming training. One of scripts is to create a maintenance plan, I encountered the following error message:

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

To fix the above mentioned error, you need to use the Agent XPs option to enable the SQL Server Agent extended stored procedures on this server. When this option is not enabled, the SQL Server Agent node is not available in SQL Server Management Studio Object Explorer.

You can enable the SQL Server Agent extended stored procedures by running the following scripts:

sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘Agent XPs’, 1;
GO
RECONFIGURE
GO

Advertisements

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: