Database Mail in Sql Server 2008 not working

Question

I am using Database Mail feature of SQL Server 2008 for the first time to send mail.

I followed the steps in Example

All seems good. Send status in

SELECT * FROM sysmail_allitems

is sent.

But the recipient hasn't received any mail..

What could be the issue?

The status from Database Mail just means SQL Server sent it to your SMTP server that is configured. Have you verified that the SMTP server received the request and forwarded it successfully? — , Sep 03 '12 at 00:49

score 0 · Answer 1 · answered Oct 21 '12 at 13:54

0

I can think of one of the following: 1. settings are incorrect. 2. anti virus or a firewall are blocking your mail.

answered Oct 21 '12 at 13:54

Idan P

2

This is not really an answer, rather a comment. – Johanna Larsson Oct 21 '12 at 15:00

score 0 · Accepted Answer · answered Nov 17 '12 at 14:44

There is a role called DatabaseMailUserRole in SqlServer your user must have access to it to send the mail through Database Mail in Sql Server

To see which users have access: EXEC msdb.sys.sp_helprolemember 'DatabaseMailUserRole';

To add user to this required role: EXEC msdb.sys.sp_addrolemember @rolename = 'DatabaseMailUserRole' ,@membername = 'userName';

Then execute the command to send mail.

2 Answers2