Let’s see how to fix the error “15281: SQL server blocked access to procedure” in this article. Bobcares, as a part of our Server Management Services offers solutions to every query that comes our way.

Error 15281: SQL Server Blocked Access To Procedure

Once we install the SQL server and try to execute a query statement, we may see the following error:

SQL Server blocked access to procedure ‘procedure’ of component ‘component’ because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘component’ by using sp_configure. For more information about enabling ‘component’, see “Surface Area Configuration” in SQL Server Books Online.

The error details are as follows:

Message Number: 15281

Severity: 16

How to fix error 15281: SQL Server Blocked Access To Procedure?

Due to security configuration, certain SQL Server features or procedures are blocked by default. As a result, some procedures are no longer available.

In order to use such procedures, a database administrator must log in to a SQL Server instance with System Administrator (SA) privileges and execute the TSQL statement listed below to enable that SQL Server functionality. In this section, we will see how we can fix it using an example, Database Mail XPs.

Error:

Fix:

USE MASTER
GO

SP_CONFIGURE 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
GO

/* Enable Database Mail XPs Advanced Options in SQL Server */
SP_CONFIGURE 'Database Mail XPs', 1
RECONFIGURE WITH OVERRIDE
GO

SP_CONFIGURE 'show advanced options', 0
RECONFIGURE WITH OVERRIDE
GO

[Need help with another query? We’re available 24/7.]

Conclusion

In this article, we provide a simple solution from our Support team to fix the above error.