Database Mail

Question

Post reply

Database Mail

pkuchaliya

Say Hey Kid

Points: 671
More actions
June 9, 2009 at 1:24 am

#134801

Hi to all,
To use database mailing i Follow the steps
1.Enable database mail in surface area configuration
2.configure smtp
3.Add database mailing option in the current login.
4.configure datbase mail.
5. enable mail profile in sql server agent properties.
6. restart the sql server agent
when i send the test mail it generate the error
-----
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 16 (2009-06-09T12:36:59). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
)
-------
when i execute the "sp_helprolemember" then it does not show the current login in the list.
Please tell how i can use database mail.
Plz help

Viewing 6 posts - 1 through 5 (of 5 total)

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

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 1

what is the port number you are using? The default is 25..try using 26. Worked for me all the time

Aurora_00 SSC Enthusiast Points: 108 More actions · Answer 2

Hi,

I am having an issue to configure the database mail. Currently i am using SQL server 2008. It always give me below error:

Error,61,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2010-10-28T13:23:03). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it xx.xx.xx.xx:25).

)

I have looked up in the net,. looking for solution, there are 4 currently which is:

1- Check the Port of the smtp server, make sure it's the correct port)

2-Check the firewall of the machine (SQL Server machine)

3- Enable the antivirus exception for Databasemail.exe

4-Check the Exchange Server whether it's denying the connection from SQL server.

All of the possibilities have been checked.

But still it's giving out above error.

Please help.

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 3

curious_sqldba

SSC-Dedicated

Points: 36494

October 29, 2010 at 7:49 am

#1244195

did you try changing to a different port no? try 26

Marco V SSCrazy Points: 2939 More actions · Answer 4

Can you telnet send a email to you re mailbox from the sql server?

here is an example how to send a mail from telnet: http://www.yuki-onna.co.uk/email/smtp.html

If this is working you at least know that youre mail server has the sql server on the access list

that you server is not blocking the mail on port 25 (does not exclude any other process using 25 like databasemail)

Aurora_00 SSC Enthusiast Points: 108 More actions · Answer 5

Thanks for help...:-D.i managed to secure a connection to SMTP server from SQL server.

The only thing i change is the port address and the SMTP server name. It seems like the previous SMTP server is having some issue.:-P