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

Create Account

Create Profile

Last modified: September 10, 2019

Author

Comments

Write a Reply or Comment