Database Mail in SQL SERVER 2005

• auac243374

  SSC Journeyman

  Points: 98

  More actions

  November 28, 2008 at 3:05 am

  #198226

  Hi

  I have been trying to send Emails from sql server 2005 Management Studio. I have configured the database mail from wizard and I have done the following

  To properly work with Database mail we have to do the following.

  I have done the following things

  1. Allowed the Database Mail option for SQL Server 2005

  From Surface Area Configurations.

  2. Sql server Agent PropertiesAlert System  Check the box Enable Mail

  Profile Choose the correct Mail Profile I have restarted the agent

  3. I have unchecked the box prevent port no 25

  Right Click on Virus Scan icon from taskbar Click on Virus Scan Console 

  Access Protection Uncheck the box prevents mass mailing worms from sending mails ok.

  4. I have added the role DatabaseMailUserRole in msdb database to the user who is using dbmail.

  Still it’s not working can anybody please help me………………….

  Thank You

  UdaCho

• Jack Corbett

  SSC Guru

  Points: 184388

  More actions

  November 28, 2008 at 7:29 am

  #904779

  Are you getting any errors? Are you trying to send mail from SQL Server Agent jobs?

  What happens when you execute sp_send_dbmail? Look it up in BOL for syntax.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question