Error when using msdb.dbo.sp_send_dbmail:
SQL Server blocked access to procedure ‘dbo.sp_send_dbmail’ of component ‘Database Mail XPs’ because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Database Mail XPs’ by using sp_configure. For more information about enabling ‘Database Mail XPs’, search for ‘Database Mail XPs’ in SQL Server Books Online.
Resolution:
Enable and configure database mail.
Go to SSMS -> Database Server -> Management -> Database Mail
![](https://customersdb.blob.core.windows.net/org/1006/photo/20a21118-5971-416f-bcf5-26f4a708ef0e.jpg)
Create Account
![](https://customersdb.blob.core.windows.net/org/1006/photo/05bf253e-3363-4abf-84bb-11fcbcb70399.jpg)
Create Profile
![](https://customersdb.blob.core.windows.net/org/1006/photo/72ae00f7-8c4c-435f-9076-bfd237db568d.jpg)
Comments