I'm trying to send a test email via Database Mail and am nor receiving it. I pinged the mail server and do get responses. I also made sure that the Agent XPs are on and that SQL Browser is running.
These are the row counts for the queries I tried.
SELECT * FROM msdb.dbo.sysmail_allitems; -- 6 items
SELECT * FROM msdb.dbo.sysmail_faileditems; -- 0 items
SELECT * FROM msdb.dbo.sysmail_unsentitems; -- 6 items status = 'unsent'
SELECT * FROM msdb.dbo.sysmail_event_log; -- 1 row (this row shows when I started the mail queue via t-sql)
Does anyone know how I can further troubleshoot this issue? Thanks for any help.