• 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