HanShi (11/25/2013)
Does the account you are using have enough permissions to use Database Mail? If possible, please try to send a mail using a sysadmin account.
Thanks for your help.
My login is sysadmin, so unless I have done something goofy I should be OK on that.
is_broker_enable = 1 (in MSDB)
check members of the DatabaseMailUserRole
DbRole MemberName MemberSID
-------------------- --------------------------- ------------------------------------------------------------------
DatabaseMailUserRole Certificate_UseDBMail_Login 0x010600000000000901000000F605E188C86F4F59B7AF1E2856BCC3A33C3B7AF7
I don't know how to interpret this data.
lists information about associations between Database Mail profiles and database principals
principal_id principal_name profile_id profile_name is_default
------------ -------------- ----------- ------------ ----------
2 guest 1 Default 1
check status of Database Mail
[font="Courier New"]SQL Server blocked access to procedure 'dbo.sysmail_help_status_sp' 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.[/font]
EXECUTE dbo.sysmail_start_sp --- start Database Mail in a mail host database
Same error message
EXEC msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail' -- list the state of the mail or status queues
queue_type length state last_empty_rowset_time last_activated_time
---------- ------ -------- ----------------------- -----------------------
mail 0 INACTIVE 2013-11-24 22:41:15.300 2013-11-24 22:41:15.300
Time here now (GetDate() ) is 2013-11-25 09:51:48.113. Colleague of mine rebooted the server last night, and re-tested DB Mail then, so that time probably reflects that action
-- show a list of all mail-items send past week
(0 row(s) affected) - No results displayed