dbmail

• ErickTreeTops

  Ten Centuries

  Points: 1253

  More actions

  March 5, 2009 at 12:22 am

  #197671

  I've setup dbmail on the sql2005 server.

  I've setup an account and a profile.

  the Test Email function works

  I am sending emails out through Operators (not sure what email method this uses)

  when i try to send out even the simplest message using sp_send_dbmail

  It says that it is queued.

  No mail message arrives and the event log states

  Mailbox unavailable. The server response was: 5.7.1 Message rejected as spam by Content Filtering.

  However the dbo.sysmail_unsentitems is empty

  So i guess the email went somewhere but not sure where or why i get a messsage saying it was blocked due to content filtering

  Can anyone assist

  Erick

• 2 Tim 3:16

  SSCarpal Tunnel

  Points: 4541

  More actions

  March 6, 2009 at 10:18 am

  #955082

  check SQL SERVER AGENT --> PROPERTIES --> Alert system --> enable mail profile.

  Tim White