I'm trying to send email using the DatabaseMail on SQL Server 2008, I can see my emails setting in the
But they just sit there, I get no error messages. I've checked I have rights to use the DatabaseMail by using the following TSQL:
EXEC msdb.sys.sp_helprolemember 'DatabaseMailUserRole';
And I have also run
EXEC msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail';
which shows the length as the number of emails I've tried to send but the Status is still showing as Inactive.
Am I missing something else here?