October 28, 2016 at 9:18 am
I am working with a client who has six SQL 2008 R2 Standard instances. I am setting up SQL Mail for notifications about available space on the data files. The configuration went through fine on five instances but there is one instance I still get an error, "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', see "Surface Area Configuration" in SQL Server Books Online. [SQLSTATE 42000] (Error 15281). The step failed.".
I enabled "Database Mail XPs" but still get the error. Any ideas on how to troubleshoot further?
Thanks a lot for your help and time.
October 28, 2016 at 11:04 am
cbarus (10/28/2016)
I am working with a client who has six SQL 2008 R2 Standard instances. I am setting up SQL Mail for notifications about available space on the data files. The configuration went through fine on five instances but there is one instance I still get an error, "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', see "Surface Area Configuration" in SQL Server Books Online. [SQLSTATE 42000] (Error 15281). The step failed.".I enabled "Database Mail XPs" but still get the error. Any ideas on how to troubleshoot further?
Thanks a lot for your help and time.
On the server where you're having a problem, run this query to check the status of your mail configuration.
SELECT name, value, value_in_use FROM sys.configurations WHERE name = 'Database Mail XPs';
Please post the output. It'll confirm your configuration.
October 28, 2016 at 1:27 pm
Ed- The output is 1 and 1.
Ed Wagner (10/28/2016)
cbarus (10/28/2016)
I am working with a client who has six SQL 2008 R2 Standard instances. I am setting up SQL Mail for notifications about available space on the data files. The configuration went through fine on five instances but there is one instance I still get an error, "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', see "Surface Area Configuration" in SQL Server Books Online. [SQLSTATE 42000] (Error 15281). The step failed.".I enabled "Database Mail XPs" but still get the error. Any ideas on how to troubleshoot further?
Thanks a lot for your help and time.
On the server where you're having a problem, run this query to check the status of your mail configuration.
SELECT name, value, value_in_use FROM sys.configurations WHERE name = 'Database Mail XPs';Please post the output. It'll confirm your configuration.
October 28, 2016 at 2:30 pm
You can try disabling database mail and then re-enabling it, that sometimes works:
EXEC sp_configure 'Database Mail XPs', 0
GO
RECONFIGURE
GO
EXEC sp_configure 'Database Mail XPs', 1
GO
RECONFIGURE
GO
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply