Post reply

Issues in Database mail

  • June 4, 2009 at 7:51 am

    #1004643

    Hi,

    I tried with the above solution but not getting the solution. Can you tell if any IIS setting is required or entry required in SMTP server to send mail?

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • June 4, 2009 at 8:02 am

    #1004652

    Sumanta Roy (6/4/2009)

    Hi,

    I tried with the above solution but not getting the solution. Can you tell if any IIS setting is required or entry required in SMTP server to send mail?

    IIS? For SMTP?? No.

  • June 4, 2009 at 8:26 am

    #1004671

    So any idea why the error is happening? I checked with the SMTP messaging team that no mails received from the SQL server.

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • June 4, 2009 at 10:53 pm

    #1005020

    HI

    Probably the problem which you are facing occurred just becuase of antivirus program, e.g McAfee Enterprise has strong security checks and also block events which hits outside of applictions.

    Follow follwing step to reconfigure mail.

    1. Disable Antivirus Program (temporary).

    2. Add port to Firewall Exception.

    3. Delete any existing Profile and Account. (which is not Working)

    4. Create new Profile and Account using following code.

    -------------------------------------------------------------------------------------------------

    --Create a Database Mail profile

    EXECUTE msdb.dbo.sysmail_add_profile_sp @profile_name = 'SENDER_EMAIL',

    @description = 'Sender Profile' ;

    -- Create a Database Mail account

    EXECUTE msdb.dbo.sysmail_add_account_sp @account_name = 'SENDER_ACCOUNT',

    @description = 'Sender Account', @email_address = 'yourname@domain.com',

    @replyto_address = 'yourname@domain.com', @display_name = 'Display Name',

    @mailserver_name = 'smtp.smpt.com' ;

    -- Add the account to the profile

    EXECUTE msdb.dbo.sysmail_add_profileaccount_sp @profile_name = 'SENDER_EMAIL',

    @account_name = 'SENDER_ACCOUNT', @sequence_number = 1 ;

    -- Grant access to the profile to the DBMailUsers role

    EXECUTE msdb.dbo.sysmail_add_principalprofile_sp @profile_name = 'SENDER_EMAIL',

    @principal_id = 0, @is_default = 1 ;

    --DISPLAY RECORD

    SELECT *

    FROM msdb.dbo.sysmail_profile

    SELECT *

    FROM msdb.dbo.sysmail_account

    -------------------------------------------------------------------------------------------------

    4. Define Basic Authentication [ID and Password] (uncheck SSL - if not using).

    5. Go to agent properties, from Alert Page configure Email.

    6. Go to History page, check on Automatically Remove Agent History.

    7. Restart SQL services and Agent.

    8. Test Email.

    9. If successful then enable antivirus program.

  • August 17, 2009 at 9:01 am

    #1040254

    All,

    The 502 command not implemented is caused because database mail or SQL mail is sending an EHLO (ESMTP command) instead of HELO (SMTP command). The receiving SMTP server does not support ESMTP or the ehlo command, hence the error message "Command Not Implemented".

    I am working with our SQL server administrator to try and change the settings to pass a helo command instead of ehlo, does anyone know how to configure this?

    Thanks,

  • August 18, 2009 at 12:03 am

    #1040635

    Hi Mike,

    Hope this may help you...

    http://www.google.co.in/search?hl=en&q=related:qa.sqlservercentral.com/articles/Administration/introtodatabasemailinsql2005/2197/

    "Don't limit your challenges, challenge your limits"

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply