Sunday , November 10 2024

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

 

ERROR MESAGGE:

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

EXPLANATION:

You may experience this error when you want to do an operation that will use SQL Server Agent.

The reason is that “Agent XPs” is inactive as mentioned in the error message.

SOLUTION:

You can enable Agent XPs (Agent Extended Stored Procedures) in two ways.

First: Start SQL Server Agent. When you start the SQL Server Agent service, Agent XPs are automatically enabled.

Second: Using the T-SQL codes that I have given below.

Loading

About Ekrem Önsoy

The original article was written in Turkish by Ekrem Önsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.

Leave a Reply

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