Error: SQL Server blocked access to procedure dbo.sp_sqlagent_notify of component Agent XPs because this component is turned off as part of the security configuration - when running a backup or maintenance task in the Blackbaud Management Console

You may receive the following error when running a backup or maintenance task in the Blackbaud Management Console:
  • SQL Server blocked access to procedure ''dbo.sp_sqlagent_notify'' of component ''Agent XPs'' because this 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.
Screen shot of error
To resolve this, enable or start the SQL Server Agent for the SQL Server instance being used by the Blackbaud application.

If the issue still persists a system administrator can enable the use of ''Agent XPs'' by using sp_configure.  Note: Blackbaud is unable to address this issue because it is related to third-party software (Microsoft SQL Server). Contact the third-party vendor for assistance.
 

Environment

 SQL Server 2008;SQL Server 2008 R2;SQL Server 2012;SQL Server 2014
 Only occurs when the the database is attached to a full edition of SQL Server. The Blackbaud Management Console does not use SQL Server agent when the database is attached to an Express edition of SQL Server.

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.