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?