Post reply

Database Mail

  • 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

  • June 9, 2009 at 8:53 am

    #1006751

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

  • October 29, 2010 at 1:39 am

    #1244004

    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.

  • October 29, 2010 at 7:49 am

    #1244195

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

  • October 29, 2010 at 8:08 am

    #1244213

    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)

  • November 4, 2010 at 1:27 am

    #1246395

    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

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

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