Issues in Database mail

Question

Issues in Database mail

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

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

Ryan007 SSCrazy Eights Points: 8275 More actions · Answer 1

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//

M Murphy SSC Enthusiast Points: 176 More actions · Answer 2

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.

Ryan007 SSCrazy Eights Points: 8275 More actions · Answer 3

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//

flash.rsn SSC-Addicted Points: 437 More actions · Answer 4

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.

mike.williams-1144364 Newbie Points: 1 More actions · Answer 5

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,

Kruti Kansara Hall of Fame Points: 3118 More actions · Answer 6

Hi Mike,

Hope this may help you...

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

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