I'm trying to turn on Database Mail.
I set the flag in db_config, did the reconfigure, and for good measure stop/started SQL Service (and thereby SQL Agent service too)
If I try to send a test email I get
"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
EXEC sp_configure 'Database Mail XPs'
name minimum maximum config_value run_value
----------------- ----------- ----------- ------------ -----------
Database Mail XPs 0 1 1 1
I also, latterly, set "SQL Mail XPs", but that hasn't made any difference either
From everything I have Googled I have not seen anything that says that this error message is caused by anything else (for example that the EMail Profile is not configured properly - I think it is, but it might not be of course!)
I haven't rebooted server, but that shouldn't be necessary should it?
My problem looks very similar to this post:www.sqlservercentral.com/Forums/Topic776651-1550-1.aspx
in that instance the O/P reinstalled SQL Server to fix it. I'd like to avoid that if possible.
Microsoft SQL Server 2008 (SP2) - 10.0.4067.0 (X64)
(Not the latest SP, I'm arranging for that to be installed in case that brings a solution, but that needs scheduled downtime which will be a while obtaining)